Administration

Question

Post reply

Administration

Arshad Ali-556241

Say Hey Kid

Points: 706
More actions
May 14, 2009 at 8:48 pm

#384594

Comments posted to this topic are about the item Administration
With Thanks and Regards
Arshad Ali
Microsoft India
My Blog - http://arshadali.blogspot.com/[/url]

Viewing 15 posts - 1 through 15 (of 27 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150467 More actions · Answer 1

Resource?

Or mssqlsystemresource?

I hate the tricksy questions ;c)

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Arshad Ali-556241 Say Hey Kid Points: 706 More actions · Answer 2

Refer to the links below for clarification:

http://technet.microsoft.com/en-us/library/ms178028.aspx

http://technet.microsoft.com/en-us/library/ms190940.aspx

With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/[/url]

Arshad Ali-556241 Say Hey Kid Points: 706 More actions · Answer 3

The physical file names of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf. By default, these files are located in :\Program Files\Microsoft SQL Server\MSSQL10.\Binn\. Each instance of SQL Server has one and only one associated mssqlsystemresource.mdf file, and instances do not share this file

With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/[/url]

Andeavour SSCrazy Points: 2600 More actions · Answer 4

Hmmm...

Caught me out, I always thought the resource database was called mssqlsystemresource. That's the name I would have expected to see in the question.

Congrats on a tricky question 😉

Jon Monahan SSCertifiable Points: 5944 More actions · Answer 5

Same here...I expected to see mssqlsystemresource in the choices. The Resource name threw me, especially since it doesn't show up under any other name.

Paul White SSC Guru Points: 150467 More actions · Answer 6

+1

Of course we have learned something so it's not all bad news.

Not sure when I will use the new information, but hey...;-)

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Noel McKinney Hall of Fame Points: 3452 More actions · Answer 7

Actually, it's the Resource database, with a capital R, not resource.

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 8

WILLIAM MITCHELL

SSChampion

Points: 13766

May 15, 2009 at 6:51 am

#995270

This same QOD was posted a long time ago. . .

Luke L SSC-Dedicated Points: 35547 More actions · Answer 9

WILLIAM MITCHELL (5/15/2009)
This same QOD was posted a long time ago. . .

yup about a year or so ago if I remember correctly. The discussion that followed was based on various parts of BOL that listed the System databases. Sometimes Resource was listed as a system db, other times it was not. Apparently those inconsistencies have been corrected...

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Steve Jones - SSC Editor SSC Guru Points: 736291 More actions · Answer 10

I always here it referred to as the Resource database, so I think it's getting straightened out.

OCTom SSChampion Points: 11785 More actions · Answer 11

Wow. 1% didn't choose Master. Interesting. :crazy:

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 12

Steve Jones - Editor (5/15/2009)
I always here it referred to as the Resource database, so I think it's getting straightened out.

and the name of msdb is actually msdbdata.mdf just to add another $0.02 worth.

Steve, can you find the link to that previous QOD?

purplebirky SSC-Addicted Points: 461 More actions · Answer 13

awesome, learned something new. keep the questions coming. 🙂

[font="Comic Sans MS"]Being "normal" is not necessarily a virtue; it rather denotes a lack of courage.
-Practical Magic[/font]

Steve Jones - SSC Editor SSC Guru Points: 736291 More actions · Answer 14

This one?

http://www.sqlservercentral.com/Questions/Tags/System+databases