How can we help you today? How can we help you today?

backup and restore of mssqlsystemresource system database

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
colby
0

Comments

1 comment

Sort by
  • Matthew Flatt
    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
    0

Add comment

Please sign in to leave a comment.