SQL Server 2005

Question

SQL Server 2005

M&M

SSC-Insane

Points: 21700
More actions
November 8, 2012 at 8:40 pm

#270751

Hi,
Is there any easy way by which we could roll back a service pack installation in SQL Server 2005 without having to reinstall SQL Server again?
M&M

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

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

sanket kokane Hall of Fame Points: 3465 More actions · Answer 1

do you have copy of mssqlresource database files before the installation of service pack .

if you are lucky and you have copy of these db files , you can replace it with current mssqlresource files ,and then you don't need to uninstall your SQL server.

-----------------------------------------------------------------------------
संकेत कोकणे

M&M SSC-Insane Points: 21700 More actions · Answer 2

sanket kokane (11/8/2012)
do you have copy of mssqlresource database files before the installation of service pack .
if you are lucky and you have copy of these db files , you can replace it with current mssqlresource files ,and then you don't need to uninstall your SQL server.

Do we have documentation on this, if so, please share it.

M&M

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 3

mohammed moinudheen (11/11/2012)
sanket kokane (11/8/2012)
do you have copy of mssqlresource database files before the installation of service pack .
if you are lucky and you have copy of these db files , you can replace it with current mssqlresource files ,and then you don't need to uninstall your SQL server.
Do we have documentation on this, if so, please share it.

Take a look at:

http://www.sqlserver-training.com/what-is-importance-of-resource-db-in-sql-server/-

and

http://www.sqlserver-training.com/what-is-importance-of-resource-db-in-sql-server/-

HTH,

Rob

M&M SSC-Insane Points: 21700 More actions · Answer 4

robert.gerald.taylor (11/11/2012)
mohammed moinudheen (11/11/2012)
sanket kokane (11/8/2012)
do you have copy of mssqlresource database files before the installation of service pack .
if you are lucky and you have copy of these db files , you can replace it with current mssqlresource files ,and then you don't need to uninstall your SQL server.
Do we have documentation on this, if so, please share it.
Take a look at:
http://www.sqlserver-training.com/what-is-importance-of-resource-db-in-sql-server/-
and
http://www.sqlserver-training.com/what-is-importance-of-resource-db-in-sql-server/-
HTH,
Rob

Thank you Rob, but not sure if people have really tried this out in production.

M&M