What is the path of mssqlsystemresource.mdf

Last Post 08 Sep 2011 07:56 AM by russellb. 7 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ogruizr
New Member
New Member

--
25 Jul 2008 01:48 PM
Hi all:

Is there a View or Table (like master_files) that tell me where the datafile mssqlsystemresource.mdf is?
ogruizr
New Member
New Member

--
28 Jul 2008 10:25 AM
Hi all

I used the following web page to move system databases.

http://msdn.microsoft.com/en-us/lib...45408.aspx

I moved master, msdb, model, tempdb and mssqlsystemresource databases from hard drive C: to another one (F: for example). Everything is working fine.

But I want in the future to know where the datafiles of mssqlsystemresource database are.

Do you have any advice or suggest about it?
ogruizr
New Member
New Member

--
28 Jul 2008 12:13 PM
I executed the following sentence:

use mssqlsystemresource
select * from sys.sysfiles

But it generated me the following error:

Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'mssqlsystemresource'. No entry found with that name. Make sure that the name is entered correctly.
ogruizr
New Member
New Member

--
30 Jul 2008 06:11 AM
I did the following last night:

1. I installed SQL Server 2005 in a test Server
2. I moved all datafiles of the system databases and mssqlsystemresource to F:\MSSQL\SYSDB
3. I installed SP2
4. I restarted the SQL Services

All worked fine.
lenolotus
New Member
New Member

--
20 Jan 2009 07:25 PM
you can use those code,
select * from sys.master_files
where db_id(N'mssqlsystemresource')
Bombayguy
New Member
New Member

--
17 Feb 2009 08:22 AM
Just to reinforce again what rm mentioned in his earlier post
it is really not a good idea to move your resource database.

I guess even guys at Microsoft has realized that in hindsight.

This seems true because in SQL Server 2008 the resource database is located in the Binn directory
and further you are not allowed to move the resource database which was possible in SQL 2005.

lenolotus: the code that have posted does not list the location or for that matter any details relating to resource database. Atleast not on my instance.

I have been unable to find any literature which indicates that we can find the location of the resource database. I guess there is none but I would be more than happy to be proved wrong in this regard.



yupsay
New Member
New Member

--
04 Sep 2011 11:26 PM
Turn on your SQL not as a service but a local program by running D:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\Binn\sqlservr.exe -sINSTANCEname -m
Even this is wrong --> net start mssql$INSTANCEname -m and would fail to get you inside RESOURCEdb

Then do a use mssqlsystemresource and it will work.
In case you want to get into the base tables hop in using DAC.
russellb
New Member
New Member

--
08 Sep 2011 07:56 AM
Yes, but there is no reason to do this. When installing SQL Server, make sure you size your drives properly, instead of moving mssqlsystemresource


Acceptable Use Policy
---