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

Rolling back Service packs (SP2 to SP1) for SQL Server 2008 Expand / Collapse
Author
Message
Posted Thursday, August 2, 2012 1:29 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, November 22, 2014 12:22 PM
Points: 131, Visits: 645
Can anyone please suggest me any method to rolling back "SQL Server 2008 SP2" to "SQL Server 2008 SP1". I am doing this only to test the rollback plan (Just in case if it is required, then we should be do this with minimum downtime).

--From Add remove, I can do this, but that will let me uninstall SP2 and take me directly to RTM. Then from there we can re-apply SP1. Although we can rollback the hotfixes via this method easily. I don't know if this method have any disadvantages. Anyone?

--But I wanted to make use of Resource database in this and not sure what process should I have to follow in order to rollback the serivce packs or Hotfixes via mssqlsystemresource.ldf and mssqlsystemresource.mdf


Any idea?

Thanks,
Arshpreet
Post #1339489
Posted Thursday, August 2, 2012 9:22 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
From Sql Server 2008 Sp1, we can uninstall updates through 'Add or Remove Programme'. Before uninstall, better take backup of all databases.
Post #1339613
Posted Friday, August 3, 2012 8:18 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, November 22, 2014 12:22 PM
Points: 131, Visits: 645
Yes; That I know of.. Thanks for the reply.

Can anyone know if Resource database can be used anyhow to rollback any patch or service packs on SQL 2008 server?


Thanks,
Arshpreet
Post #1339862
Posted Monday, August 6, 2012 11:58 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, November 22, 2014 12:22 PM
Points: 131, Visits: 645
Well I tried all the options but still no use of resource database at all to rollback any patch.
Post #1340800
Posted Tuesday, August 7, 2012 3:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 24, 2014 11:01 PM
Points: 18, Visits: 446
As per my expirince you can't roll back SP using Resource database as it is read only and hidden.
Post #1341080
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse