Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resource database ? Expand / Collapse
Author
Message
Posted Tuesday, August 25, 2009 8:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
Following error is observed whern I try to attach the resource database: Can anyone tell me any article for resource database. Why it is used?

TITLE: Microsoft SQL Server Management Studio
------------------------------

An error occurred when attaching the database(s). Click the hyperlink in the Message column for details.

------------------------------
BUTTONS:

OK
------------------------------
Post #776748
Posted Tuesday, August 25, 2009 8:49 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
... attaching resource database?

BOL or Google mssqlsystemresource.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #776752
Posted Tuesday, August 25, 2009 9:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
I didn't find any convincing posts on google and so pinged here. I understand this is a database that is helpful when we upgrade the sql server, patching etc.

Following are some information regarding this database

SELECT SERVERPROPERTY('ResourceVersion');
SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');

Can this be used in case our master database is corrupted? When this will be used. I understand this consists of all the system views, sps tables etc. What is the basic use of this ?

-LK
Post #776783
Posted Tuesday, August 25, 2009 9:17 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:11 PM
Points: 31,368, Visits: 15,837
Don't attach. Shut down SQL and copy files

http://weblogs.sqlteam.com/mladenp/archive/2007/03/12/60132.aspx







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #776792
Posted Tuesday, August 25, 2009 9:25 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
luckysql.kinda (8/25/2009)
I didn't find any convincing posts on google

first google hit for "mssqlsystemresource database"... http://msdn.microsoft.com/en-us/library/ms190940.aspx

What is the basic use of this

trap curious people and, it works!

Didn't you mother told you years ago: don't pet a dog you don't know, don't eat a berry you don't know is poisonous or not and, don't touch mssqlsystemresource database until you read BOL?


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #776800
Posted Tuesday, August 25, 2009 9:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
My question is whether this can be used if the master database is corrupted.

((Anyway we don't need to shut down the sql server and copy files. Simply create a test database and take this offline and then copy files. )) I did that right now ...

-LK
Post #776804
Posted Tuesday, August 25, 2009 9:29 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
luckysql.kinda (8/25/2009)
My question is whether this can be used if the master database is corrupted.

No, it can't


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #776806
Posted Tuesday, August 25, 2009 12:17 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:24 AM
Points: 293, Visits: 828
http://msdn.microsoft.com/en-us/library/ms190940%28SQL.90%29.aspx
Post #776957
Posted Tuesday, August 25, 2009 1:00 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
Jon.Morisi (8/25/2009)
http://msdn.microsoft.com/en-us/library/ms190940%28SQL.90%29.aspx

Did you find it by yourself or just copy/pasted from my second post?


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #777006
Posted Tuesday, August 25, 2009 2:08 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:24 AM
Points: 293, Visits: 828
hehe, I just looked at the topic, then my favorites :)
Post #777064
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse