SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Little info about Resouce DB (SQL Server 2008-2005)

Little info about System Resource Database in (SQL Server 2008/2005)

The fifth system database in both versions (SQL Server 2008 - 2005) is Resource Database. In this DB we have all relevant information about systems objects and functions that we use every day in our daily routine, such as:


SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');



The Resource Database is the read-only DB , all sys.objects in SQL Server are organized in this DB physically and logically are appears in sys schema of every DB.

Physical name for the Resource Database are mssqlsystemresource.mdf - data file and mssqlsystemresource.ldf - log file, the location has been changed and it is different in both versions.

SQL Server 2008
SystemDrive:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\.

SQL Server 2005
SystemDrive:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\

The Resource DB depends from master DB, so if you remove your master DB also you will move the Resource DB.

SQL Server cannot backup up the Resource DB, it can be done manually and the restore should be done manually as well, and must be careful to not overwrite the current Resource DB.

More and other related info about Resource DB can be checked from here.

Dukagjin Maloku - Dugi'DBA

Everything that I can post for the SQL Server ...


No comments.

Leave a Comment

Please register or log in to leave a comment.