What are the challenges you face when working across database platforms? Take the survey

backup and restore of mssqlsystemresource system database

colbycolby Posts: 30
edited May 30, 2008 4:32AM in SQL Backup Previous Versions
SQL 2005 has 5 system databases and Red Gate SQL backup v5 can only backup 4 of the 5 system databases. What is your recommendation for backing up/restoring of the mssqlsystemresource.mdf database?

The below link refers to this database.

http://www.sqlcommunity.com/TipsTricks/ ... fault.aspx




  • Options
    Hi Colby

    Thank you for your forum post.

    The resource database can not be backed up by SQL Server as far as i'm aware.

    You have to back up the physical files with a Windows backup program. In the event that you need to restore, the files can be restored back to the same place and the SQL Service started.

    Please let me know if this helps.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.