Rollback Service Pack???

Question

Post reply

Rollback Service Pack???

Oracle_91

SSChampion

Points: 14548
More actions
July 19, 2009 at 11:29 am

#385012

Hi Friends,
Can we rollback a service pack which is already installed.
If so, what are the steps involved?
Thanks in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

you would have to un-install, re-install the SQL instance.

---------------------------------------------------------------------

Chand00 SSCertifiable Points: 6466 More actions · Answer 2

Hi Mahesh,

You cannot rollback service packs upto 2005. This feature is available in 2008

[font="Verdana"]Thanks
Chandra Mohan[/font]

Oracle_91 SSChampion Points: 14548 More actions · Answer 3

Oracle_91

SSChampion

Points: 14548

July 20, 2009 at 11:53 am

#1027201

Thanks for the valuable suggestions.

JasonRowland SSC Eights! Points: 951 More actions · Answer 4

For a default instance installed on a single server with user databases on seperate drive than "c:\" and all system databases in "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" would the following steps provide a viable rollback? I know it's not uninstalling and reinstalling sql server, but in theory everything being touched by the service pack would be restored to its previous state.

1. Backup the system state.

2. Backup C:\Program Files\Microsoft SQL Server\*.*

3. Detach all user databases.

4. Install service pack.

5. Service pack doesn't install properly.

6. Restore items from 1 and 2.

7. Reattach user databases.

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 5

JasonRowland (3/2/2011)
For a default instance installed on a single server with user databases on seperate drive than "c:\" and all system databases in "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" would the following steps provide a viable rollback? I know it's not uninstalling and reinstalling sql server, but in theory everything being touched by the service pack would be restored to its previous state.
1. Backup the system state.
2. Backup C:\Program Files\Microsoft SQL Server\*.*
3. Detach all user databases.
4. Install service pack.
5. Service pack doesn't install properly.
6. Restore items from 1 and 2.
7. Reattach user databases.

One thought to this... most people put the master, model, msdb, temp .mdf and .ldf data files on another drive other than C. There would need to be another step in your process to cover that.