The Resource database is a read only, hidden system database that contains all the SQL Server system objects such as sys.objects which are physically available only in the Resource database, even though they logically appear in the SYS schema of every database. The Resource Database does not contain any user data or any user metadata. By design, the Resource database is not visible under SQL Server Management Studio’s Object Explorer | Databases | System Databases Node.
The DBA shouldn’t rename or move the Resource Database file. If the files are renamed or moved from their respective
locations then SQL Server will not start. The other important thing to be considered is not to put the Resource Database files in
a compressed or encrypted NTFS file system folders as it will hinder the performance and will also possibly prevent upgrades.
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment