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('ResourceVersion');

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

Add new comment