DaveWentzel.com            All Things Data

Resource Database


Resource Database
A hidden, r/o db that contains all the system objects that are included with SQL2K5.  These were formerly in the master database. 
Backups are not necessary.  It is there simply to make upgrading to a new version easier and faster. 

SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');
The only way to access it is to start sql server in single-user admin mode (-m)

Add new comment