January 30, 2013 at 7:59 am
We are planning on doing a SQL service pack upgrade soon.
Should we take the databases offline, or can the service pack be applied while everything is up and running?
Just trying to avoid any problems.
Thanks.
Michal.
January 30, 2013 at 10:22 am
don't take the database offline per se (i.e. don't issue alter database set offline) but do plan an outage and stop all connections to the database before you start, and back everything up before you start as well.
---------------------------------------------------------------------
January 31, 2013 at 5:08 am
The Service Pack installer will manipulate the state of the service so connections will be interrupted or impossible at specific times during the upgrade. Definitely test the upgrade in a non-production environment first. While upgrading your test environment you can attempt to access the instance to see how it behaves while the service pack is being applied.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 31, 2013 at 5:52 am
if your application is the type that runs as a service and jumps into SQL as soon as it detects it running you could hit problems with the upgrade in that case. I have had an upgrade fail when developers connected, but admittedly that was SQL2005. Best Practice is to stop connections first.
If you were to try letting the application loose whilst an upgrade is running make sure you know how to back out of an upgrade failure.
---------------------------------------------------------------------
January 31, 2013 at 6:41 am
Agreed Best Practice is to try and keep everyone away from the instance during an upgrade but I think 'script upgrade mode' protects the instance now. All concerns surrounding taking backups before the upgrade apply as well, in case a rollback is needed for a failed upgrade and inconsistent resulting state. SPs for 2008 and newer can be uninstalled too.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply