June 25, 2009 at 7:08 am
hi,
i'm upgrading sqlserver 2005 to SP1, Is there any precautions to take care of things.
before that we have RTM(Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)).
Please give guidelines.
🙂
June 25, 2009 at 7:15 am
There is Service pack 3 Available for SQL server 2005. how about upgrading to SP3 directly.
Sp1 had some Memory leak issues still pending and were solved in SP2, but SP3 is stable as i have them applied on my Server ...
General guidelines are have the latest backups of your databases (just in case)
If you see locked Files while the SP check for locked files.. goto services and Stop the SQL services... you can slso do this before hand...
While applying the Service pack.. check you have admin right on the machine or are logged on as administrator. Or logged on as the Service account used by the SQl server...
This is important as lot of SP updates tend to fail on permission issues and people spend a lot of time to figure out whats happening....
Maninder
www.dbanation.com
June 25, 2009 at 7:16 am
firstly, why upgrade to SP1, SP3 is out, upgrade to that.
Back up all your databases first, especially system databases.
If you are able to , stop the services first and copy all the system databases files except tempdb off to another location (on the same server). Repeat that after the install is complete. This will make recovery easier if you have to back out.
ensure no-one else can connect whilst you run the upgrade
ensure the account you are running the upgrade under has sufficient privileges
If you want to avoid a reboot afterwards, stop all services holding locks on files (you will be informed which these are during the upgrade_. It will still work if you don't do this, but you will have to reboot the server.
---------------------------------------------------------------------
June 25, 2009 at 7:19 am
two people said the same thing, we must be right! 🙂
---------------------------------------------------------------------
June 25, 2009 at 7:24 am
😀 We must be the long lost brothers 😀
Maninder
www.dbanation.com
June 25, 2009 at 7:25 am
what is RTM,
🙂
June 25, 2009 at 7:26 am
thanks for you r response.
🙂
June 25, 2009 at 7:36 am
vrabhadram (6/25/2009)
what is RTM,
RTM = Release To Market
---------------------------------------------------------------------
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply