August 2, 2012 at 1:29 pm
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
August 2, 2012 at 9:22 pm
From Sql Server 2008 Sp1, we can uninstall updates through 'Add or Remove Programme'. Before uninstall, better take backup of all databases.
August 3, 2012 at 8:18 am
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
August 6, 2012 at 11:58 am
Well I tried all the options but still no use of resource database at all to rollback any patch.
August 7, 2012 at 3:05 am
As per my expirince you can't roll back SP using Resource database as it is read only and hidden.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply