Resource database is an hidden SQL Server system database. We cannot see these database listed in any SQL Server Client Tool(SSMS) and SQL Server commands.
It is an important resource of MSSQLSERVER because it will contain all the System Objects of SQL Server . System objects mean that SQL Server maintain all the metadatas and data of tables and views ,Stored Procedures in the System tables and DMV .These System tables and DMVs and System function all are considered as System objects.
It does not contain user details of SQL Server Instance.
The objects in the resource database are made available through logical links in the sys schema of all databases. Where the System objects also have hidden objects we can view those objects when we have an sysadmin permission.
The location of resource database is
C:\Program Files\Microsoft SQLServer\Instance_Name\MSSQL\Binn\mssqlsystemresource.mdf
C:\Program Files\Microsoft SQL Server\Instance_Name\MSSQL\Binn\mssqlsystemresource.ldf
We cannot change the path location of this database.
When we try to connect SQL Server Instance in Single User Mode then we can access the Resource database using queries.
Single User Mode means that at a time we can establish only one connection to a database.In most of the cases accessing a database in an single user mode is securable.
We cannot take a backup of Resource database.The resource database file is like a normal binary file. We can have copy that file in different location. For some reason, the Resource database has been corrupted or is unusable or unavailable then using the Repair option in the SQL setup would be the preferred method to repair the SQL server installation.
We cannot attach resource database to an SQL Server Instance. Because it is like a normal file but it has the extension of .mdf.
Got questions? Email us at: vembu-support@vembu.com for answers.
Follow our Twitter and Facebook feeds for new releases, updates, insightful posts and more.
