Home Forums SQL Server 2005 Backups Backup mssqlsystemresource database RE: Backup mssqlsystemresource database

  • February 18, 2011 at 6:46 am

    #1288801

    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