March 17, 2010 at 7:34 pm
Hi...
Can anyone share me the Best Practices for Applying Service Packs and Hotfixes in sql server 2005 ?
Thanks in Advance
March 17, 2010 at 9:39 pm
sudhakara (3/17/2010)
Hi...Can anyone share me the Best Practices for Applying Service Packs and Hotfixes in sql server 2005 ?
Thanks in Advance
The best practice is to install them in a non-production environment first. Test your apps, and then promote the sp to production.
Always perform the patching during maintenance windows.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 17, 2010 at 10:57 pm
Applying Hotfix on test and DEV enviorment is always the best practice, but while applying patches plz keep in mind to stop sql services , bcoz it mostly aviods rebooting of the server.
March 18, 2010 at 8:13 am
ananthbhaskar (3/17/2010)
Applying Hotfix on test and DEV enviorment is always the best practice, but while applying patches plz keep in mind to stop sql services , bcoz it mostly aviods rebooting of the server.
Thanks your reply and sharing your ideas. It will be very helpful if you people can share the prerequisites and post check list for applying the service packs.
March 18, 2010 at 8:39 am
ensure no connections to the databases and backup systemdbs before you start, including resource database
---------------------------------------------------------------------
March 18, 2010 at 8:55 am
george sibbald (3/18/2010)
ensure no connections to the databases and backup systemdbs before you start, including resource database
Good recommendation
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 18, 2010 at 8:57 am
sudhakara (3/18/2010)
Thanks your reply and sharing your ideas. It will be very helpful if you people can share the prerequisites and post check list for applying the service packs.
Checklists will depend on your applications and your environment.
Prerequisites??
The listing for the SP will have what the SP fixes. You can find that information at microsoft.com
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply