Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server 2005
Add to briefcase

SQL Server 2005 Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
mohammed moinudheen
Posted Thursday, November 08, 2012 8:40 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582
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?

Mohammed Moinudheen
Post #1382804
sanket kokane
Posted Thursday, November 08, 2012 10:47 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 1:13 AM
Points: 323, Visits: 964
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.

-----------------------------------------------------------------------------
संकेत कोकणे
Post #1382822
mohammed moinudheen
Posted Sunday, November 11, 2012 12:54 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582
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.

Mohammed Moinudheen
Post #1383461
robert.gerald.taylor
Posted Sunday, November 11, 2012 2:47 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 11:10 AM
Points: 740, Visits: 785
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
Post #1383467
mohammed moinudheen
Posted Sunday, November 11, 2012 11:18 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582
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.

Mohammed Moinudheen
Post #1383504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.