Resource database

Today learned new thing about Resource database, as everybody knows resource database is the system database introduced in sql server 2005, this database is hidden and user cannot see and access it directly, all the sys. schema (system objects) are stored in this database.

This database is very important and all DMV/DMF are stored in it. and it is generally (data and log – mdf/ldf) files are at the same location as that of Master database.

on sql server 2005 – this database files can be moved to new location – with master.

but from sql server 2008 onwords microsoft kept it fixed and we cannot move the resource database.

ref:

SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.100).aspx
SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.105).aspx
SQL Server 2005: http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx

This I learned in QOD at http://www.sqlservercentral.com/Questions

Thanx.

Vinay

*Sorry I missed Blog on Feb….

About these ads
This entry was posted in Computers and Internet, General, Limitation, What I learned today and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s