Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Applying Service Packs to SQL server Expand / Collapse
Author
Message
Posted Thursday, December 13, 2012 3:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 4:47 AM
Points: 171, Visits: 600
Hi,

I want to apply SP3 to our current SQL Server 2008 instances which are currently on SP1.

Our server is currently mirrored, so my steps to apply the service pack with no downtime are as follows:

1) Stop mirroring on secondary server.
2) Apply the service pack to the mirrored secondary server.

3)Start Mirroring, once in sync force fail over to secondary server.
4)Apply Service pack to Principal Server
5) Reestablish Mirroring from Principal to secondary.

Can you mirror between different versions of service pack?

I have never applied a service pack to a production environment.
Are there any potential pitfalls I should be aware of? Also are there any guides to applying a service pack?

Many Thanks bugg

Post #1396092
Posted Thursday, December 13, 2012 3:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 13, 2013 4:35 AM
Points: 386, Visits: 211
http://technet.microsoft.com/en-us/library/bb497962.aspx


Cursors never.
DTS - only when needed and never to control.
Post #1396094
Posted Thursday, December 13, 2012 4:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 4:47 AM
Points: 171, Visits: 600
Awesome , thankyou
Post #1396099
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse