Administration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Arshad Ali » Administration

28 posts, Page 1 of 3

1 2 3 »»»

Administration

Rate Topic

Display Mode

Topic Options

Author

Message

Arshad Ali-556241

Posted Thursday, May 14, 2009 8:48 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:41 AM
Points: 64, Visits: 179

Comments posted to this topic are about the item Administration

With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/

Post #717544

Paul White

Posted Thursday, May 14, 2009 8:49 PM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

Resource?

Or mssqlsystemresource?

I hate the tricksy questions ;c)

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #717546

Arshad Ali-556241

Posted Friday, May 15, 2009 12:10 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:41 AM
Points: 64, Visits: 179

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/

Post #717631

Arshad Ali-556241

Posted Friday, May 15, 2009 12:12 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:41 AM
Points: 64, Visits: 179

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/

Post #717632

Andeavour

Posted Friday, May 15, 2009 5:09 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 5:34 AM
Points: 981, Visits: 821

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 Wink

Post #717757

Jon Monahan

Posted Friday, May 15, 2009 5:59 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:38 AM
Points: 2,151, Visits: 99

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.

Post #717778

Paul White

Posted Friday, May 15, 2009 6:20 AM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

+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... Wink

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #717797

Noel McKinney

Posted Friday, May 15, 2009 6:28 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767

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

Post #717808

WILLIAM MITCHELL

Posted Friday, May 15, 2009 6:51 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:45 AM
Points: 1,441, Visits: 2,485

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

Post #717840

Luke L

Posted Friday, May 15, 2009 7:54 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:12 PM
Points: 2,891, Visits: 5,857

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

For better help with performance problems please read this

Post #717919

« Prev Topic | Next Topic »

28 posts, Page 1 of 3

1 2 3 »»»

Permissions