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