August 25, 2009 at 8:42 am
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
------------------------------
August 25, 2009 at 8:49 am
:w00t: ... 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.August 25, 2009 at 9:15 am
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
August 25, 2009 at 9:17 am
Don't attach. Shut down SQL and copy files
http://weblogs.sqlteam.com/mladenp/archive/2007/03/12/60132.aspx
August 25, 2009 at 9:25 am
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.August 25, 2009 at 9:28 am
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
August 25, 2009 at 9:29 am
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.August 25, 2009 at 12:17 pm
August 25, 2009 at 1:00 pm
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.August 25, 2009 at 2:08 pm
hehe, I just looked at the topic, then my favorites 🙂
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply