Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup mssqlsystemresource database Expand / Collapse
Author
Message
Posted Friday, February 18, 2011 6:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 11, 2012 3:55 PM
Points: 86, Visits: 206
Hi

I want to backup resource database ( hidden database ) in my base machine ( sql server 2005 ) .
I want to restore it with a different name ao that i am able to see the data present in the database .

Pls guide me .

I came across an article in the link : http://www.mssqltips.com/tip.asp?tip=1544 .
I tried doing it that way using the xcopy command but it just copied the mdf and ldf files for me to a different location .

How is it same as the backup ? < as mentioned in the article >

Regards,
Abhishek Dwivedi.
Post #1066332
Posted Friday, February 18, 2011 6:46 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:05 AM
Points: 42,469, Visits: 35,540
abhishek_dwivedi03 (2/18/2011)
I want to restore it with a different name ao that i am able to see the data present in the database .


Shut down SQL, take a copy of the mdf and ldf files, restart SQL then attach those copied files as a user database. You cannot take a SQL backup of the system resource DB as it is hidden.

There's not much data in there, far more it's procedures, views, functions and the like.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1066340
Posted Friday, February 18, 2011 7:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 11, 2012 3:55 PM
Points: 86, Visits: 206
I followed the steps but i am getting an error message which says :

You cant perform this operation for the resource database

error :4616
Post #1066362
Posted Friday, February 18, 2011 7:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:05 AM
Points: 42,469, Visits: 35,540
At what point?

I've done exactly what I told you to do, so I know it does work.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1066364
Posted Friday, February 18, 2011 10:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 11, 2012 3:55 PM
Points: 86, Visits: 206
While performing the step :

attach those copied files as a user database.
Post #1066497
Posted Friday, February 18, 2011 12:31 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:05 AM
Points: 42,469, Visits: 35,540
From object explorer, attach database, select the files, give it a new name, click ok.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1066574
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse