Backup mssqlsystemresource database

  • 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.

  • 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, MVP, M.Sc (Comp Sci)
    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
  • I followed the steps but i am getting an error message which says :

    You cant perform this operation for the resource database

    error :4616

  • 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, MVP, M.Sc (Comp Sci)
    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
  • While performing the step :

    attach those copied files as a user database.

  • From object explorer, attach database, select the files, give it a new name, click ok.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

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

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