All system stored procedures, views and functions are stored here.
This database is hidden from the user. We can't view it in Object Explorer or with the use of sp_helpDB or by selecting from a sys.databases view. Resource database does not contain any of user data. This database has to be backed up using file-based backup or by using Drive Backups.
So how do we know its presence?
-Go to the Data directory of your SQL installation [Install Drive]
If you want to see what is there in this database:
- Stop the SQL Server service.
- Copy both files and rename the copies to MSSQLSystemResource_Test.mdf and MSSQLSystemResource_Test.ldf.
- Start the SQL server service
- Attach the new files.
- Query the database.