Rolling back Service packs (SP2 to SP1) for SQL Server 2008

  • 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

  • From Sql Server 2008 Sp1, we can uninstall updates through 'Add or Remove Programme'. Before uninstall, better take backup of all databases.

  • 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

  • Well I tried all the options but still no use of resource database at all to rollback any patch.

  • 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