System Database Archives - Page 7 of 7 - SQL Authority with Pinal Dave

A grand piano with its lid raised, showing the strings and hammers inside, one hammer painted red.

Resource Database Quiz: Where Do the System Objects Live?

January 19, 2012

SQL Backup and Restore, SQL Server Architecture, SQL System Table, System Database

This Resource Database Quiz asks where SQL Server stores the definition of sys.objects and whether BACKUP DATABASE can protect it. The answer is the hidden Resource database. A tested script shows its version, its date and the system objects every database sees.