September 1, 2009 at 10:56 pm
hi,
We just planning to update the SQL server2005 with SP3, Present we have RTM. What i need to take care about this hotfix. How can i upgrade to this service pack(SP3)
thanks,
🙂
September 2, 2009 at 4:34 am
Backups, backups, backups!
Firstly i cant beleive your still running RTM. Have you not noticed how your maint plans tend to corrupt each time you change them?
Have a good read of BOl and MS forums, there are some reported gotchas, personally i had no probs with my clustered prod system but some people reported issues re-creating the mssqlresource database.
The one thing we had to do was manually run the components on out passive node after for non-clustered services (the sp is cluster aware, but some services arent).
Have fun 😎
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 3, 2009 at 12:25 pm
The most important advice that I can give, after you do you homework first, is try it on a test server !
I cannot stress enought 'testing' the process on another server first especially since I sense you are very new to both SQL Server and the DBA role.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 3, 2009 at 5:35 pm
dba-vb (9/1/2009)
hi,We just planning to update the SQL server2005 with SP3, Present we have RTM. What i need to take care about this hotfix. How can i upgrade to this service pack(SP3)
thanks,
Ouch!
Make sure you back up your system databases along with your user databases in case you need to rollback to pre-sp3.
I like to test major service packs at least twice - dev and then QA environments - before releasing it to prod.
Also, make sure that you read up on the SP first and understand the bugs fixed and any new possible gotchas realted to the release.
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
September 4, 2009 at 3:02 am
make sure that when you do this, you allow enough time, so it can be rolled backed without impacting on business use if you have to rollback. also make sure that existing applications have been tested with this service pack, so you have no unexpected application issues after you have done this service pack.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply