Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-08-07 : 22:42:49
|
| Hi All,Can anyone share information about rollbacking a service pack?What are pre-cautionary steps i can take in SQL 2005 ? and What are pre-cautionary steps i can take in SQL 2008 ? Assume that i have a cluster, then how to rollback a service on a sql cluster?I can take a backup of the binaries and data file location before applying the serive pack.Is that a way to rollback a service pack?Thanks in Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-08-08 : 16:25:08
|
| You cannot rollback a service pack prior to SP1 of SQL Server 2008. I believe as of SP1 - there is the option of uninstalling the service pack.If I were to run into that situation myself, I probably would end up performing a full uninstall/reinstall instead of taking the risk of breaking my system by rolling back a service pack.Jeff |
 |
|
|
|
|
|
Rollbacking a patch ???