http://www.sqlservercentral.com/blogs/dugi/2009/12/28/little-info-about-resouce-db-sql-server-2008-2005/

Printed 2014/07/26 02:02PM

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

By Dukagjin Maloku, 2009/12/28

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

SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');
GO

SELECT OBJECT_DEFINITION(OBJECT_ID('sys.objects'));
GO

SELECT SERVERPROPERTY('Edition');
GO


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.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.