Patches for new SQL2005 instance

50 pts.
Tags:
SQL Server
SQL Server 2005
HI would like to know if we need to apply patches for a newly created instance if the default instance has already been patched to SP2 Thks for any info

Answer Wiki

Thanks. We'll let you know when a new response is added.

there is no hard and fast rule as to what level of patching should be done – it is variable depending upon each situation. You want to be sure you have any and all security updates, while not just adding random updates that are supposed to fix a problem that you do not have. There is always the chance that any patch can cause problems with your install or apps in addition to fixing the problem they are documented to fix!
Personally, to get a good balance of stability (not having a new version every other week) and protection/functionality, I have chosen to upgrade my servers with each hotfix *rollup* release, rather than with each individual update released by Microsoft. You can get a current release list here:

http://www.sqlservercentral.com/articles/Administration/2960/

Of course, you want to test any update on a non-critical server (preferably Dev/Test) first, before updating a critical Production server.

D –

DT2115 | Apr 25 2008 1:28PM GMT

Wow – I just re-read this question and see that I completely missed the point. Yes, you do need to rerun any security updates after installing a new named instance, even if the default instance previously installed was already upgraded to SP2. When you launch SP2, it will review all installed SQL instances and tell you which ones (and which components) the upgrade will apply to.

HTH,

D

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DT2115
    Wow - I just re-read this question and see that I completely missed the point. Yes, you do need to rerun any security updates after installing a new named instance, even if the default instance previously installed was already upgraded to SP2. When you launch SP2, it will review all installed SQL instances and tell you which ones (and which components) the upgrade will apply to. HTH, D
    55 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following