SQL Server 2008 Enterprise SP upgrade

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL Server 2008 Enterprise SP upgrade

SQL Server 2008 Enterprise SP upgrade

Rate Topic

Display Mode

Topic Options

Author

Message

Michal-469362

Posted Wednesday, January 30, 2013 7:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 14, 2013 1:44 PM
Points: 3, Visits: 59

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.

Post #1413645

george sibbald

Posted Wednesday, January 30, 2013 10:22 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 5,264, Visits: 11,191

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.

---------------------------------------------------------------------

Post #1413710

opc.three

Posted Thursday, January 31, 2013 5:08 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 6,693, Visits: 11,707

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1414006

george sibbald

Posted Thursday, January 31, 2013 5:52 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 5,264, Visits: 11,191

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.

---------------------------------------------------------------------

Post #1414036

opc.three

Posted Thursday, January 31, 2013 6:41 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 6,693, Visits: 11,707

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1414092

« Prev Topic | Next Topic »

Permissions