Home Forums SQLServerCentral.com Editorials What Do You Include in Your Database Maintenance Plans? RE: What Do You Include in Your Database Maintenance Plans?

  • Thanks for taking the time to reply!

    I think you have already answered this next question, but in case you have more to say, I'll go ahead and ask it:

    I came across an article that talks about the importance of backing up the hidden Resource database:

    "...in SQL Server 2005 and higher versions there is a new hidden read only system database named Resource database which was introduced by Microsoft. ... Resource database basically contains copies of all system objects that are shipped with SQL Server 2005 and SQL Server 2008. In order to take the backup of Resource Database you need to perform a file based or a disk based backup of mssqlsystemresource.mdf and mssqlsystemresource.ldf files, by treating the files as if they were like any other binary files, instead of a database file.  In Maintenance Plan as there is no other task available which ... The command used for copying mssqlsystemresource.mdf and mssqlsystemresource.ldf files is mentioned below. ..."

    from: http://www.sql-server-performance.com/articles/dba/Backup_System_Databases_Using_Maintenance_Plans_p3.aspx%5B/quote%5D

    Do you have any opinions on this? I've never heard of this before, but it sounds important.