sql backup master service failed to start

In SQL Server 2000, whenever a service pack is applied, all the system objects that reside on both system and user databases will be updated, making it more difficult to rollback the change whenever necessary. The Resource database makes it easy for service packs to be applied or rolled back whenever necessary. It complements the master database in a sense as the SQL Server service now also depends on this database. These objects physically exist in the Resource database but logically appear in the sys schema of every database on the instance. It contains all the system objects that ship with SQL Server 2005.

This is the reason why it does not appear in SQL Server Management Studio. The Resource database (shortly referred to as RDB) is a hidden, read-only database that contains all the system objects that are included with SQL Server 2005. How do we backup and restore the Resource database? Unfortunately, this database does not show up in SQL Server Management Studio for me to include in my database backups. I have been hearing about the Resource database in SQL Server 2005 and that it should be included in our system database backups. SQL Server backup and restore of the Resource databaseīy: Edwin Sarmiento | Updated: | Comments (9) | Related: More > Backup

Sql backup master service failed to start