Options

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

Thanks

Colby
· Share on Twitter

Comments

  • Options
    Matthew FlattMatthew Flatt Posts: 255 Bronze 5
    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
    · Share on Twitter
Sign In or Register to comment.