SQL Server 2005 SP3 installation problem
-
Is it true that whenever we install sql server 2005 service pack 3, the sql server will go to single user mode??
I was trying to install SQL Server 2005 service pack 3 in one of our production server and all the connections to that server failed during that time...
What is the standard procedure to install service pack on SQL Server...I.E. if we want to install sp3 on one of our production server then which process we need to follow?
Thanks
-
yes, the service pack puts the SQL instance in single user mode as part of the upgrade as it is updating system catalogs.
Procedure:
Stop all connections to the databases(s), i.e turn off the applications. This is vital.
Back up databases, especially system databases
Stop SQL
do a file copy of the mssqlsystemresource database at least, good idea to do other system databases (this is needed if a backout is required)
apply the service pack
back up system databases
At this point personally I would stop sql again to take file copies of the system databases as these could be very useful in a Disaster recovery
restart SQL
done
---------------------------------------------------------------------
-
george sibbald (7/17/2009)
yes, the service pack puts the SQL instance in single user mode as part of the upgrade as it is updating system catalogs.Procedure:
Stop all connections to the databases(s), i.e turn off the applications. This is vital.
Back up databases, especially system databases
Stop SQL
do a file copy of the mssqlsystemresource database at least, good idea to do other system databases (this is needed if a backout is required)
apply the service pack
back up system databases
At this point personally I would stop sql again to take file copies of the system databases as these could be very useful in a Disaster recovery
restart SQL
done
Can you tell me the steps and precaustions if i want to apply SP3 on Failover cluster ?
-
A quick google search brings up this
process basically the same.
apply the SP to the active mode, use cluster admin if you want to stop SQL, run the SP from a share the other node has access to.
---------------------------------------------------------------------
-
george sibbald (7/18/2009)
A quick google search brings up thisprocess basically the same.
apply the SP to the active mode, use cluster admin if you want to stop SQL, run the SP from a share the other node has access to.
thks for your reply..
thing is some artical sayinng ,stop or bring offline pasive nodes of cluster before applying the service pack ..some articals saying keep passive nodes in cluster before applying the service pack ..thats y posted my questions here.. i am not clear on this ..there is also no reason why should i stop or should not stop ...
-
I have never applied a SP to a multi node cluster so I won't comment on that, but if this is a two node cluster leave both nodes UP and apply to the active node.
Don't believe any blogs you might have seen, don't even believe me, go from the instructions I gave you a link for and official sites such as msdn and BOL.
Just make sure you have everything backed up before you start.
I only say stop SQL as I like to have file copies of the system database files so I can avoid messy rebuilds if I have to reinstall.
---------------------------------------------------------------------
-
george sibbald (7/18/2009)
I have never applied a SP to a multi node cluster so I won't comment on that, but if this is a two node cluster leave both nodes UP and apply to the active node.Don't believe any blogs you might have seen, don't even believe me, go from the instructions I gave you a link for and official sites such as msdn and BOL.
Just make sure you have everything backed up before you start.
I only say stop SQL as I like to have file copies of the system database files so I can avoid messy rebuilds if I have to reinstall.
thks for sharing your knowledge ...
-
george sibbald (7/18/2009)
I have never applied a SP to a multi node cluster so I won't comment on that, but if this is a two node cluster leave both nodes UP and apply to the active node.Don't believe any blogs you might have seen, don't even believe me, go from the instructions I gave you a link for and official sites such as msdn and BOL.
Just make sure you have everything backed up before you start.
I only say stop SQL as I like to have file copies of the system database files so I can avoid messy rebuilds if I have to reinstall.
George's tip on copying the system databases files will save you a lot of time during a disaster.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply