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 123»»»

Administration Expand / Collapse
Author
Message
Posted Thursday, May 14, 2009 8:48 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 6:25 AM
Points: 64, Visits: 189
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
Posted Thursday, May 14, 2009 8:49 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:07 PM
Points: 11,194, Visits: 11,109
Resource?

Or mssqlsystemresource?

I hate the tricksy questions ;c)




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #717546
Posted Friday, May 15, 2009 12:10 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 6:25 AM
Points: 64, Visits: 189
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
Posted Friday, May 15, 2009 12:12 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 6:25 AM
Points: 64, Visits: 189
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
Posted Friday, May 15, 2009 5:09 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:59 AM
Points: 987, Visits: 868
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



Post #717757
Posted Friday, May 15, 2009 5:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:06 PM
Points: 2,618, Visits: 112
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
Posted Friday, May 15, 2009 6:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:07 PM
Points: 11,194, Visits: 11,109
+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
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #717797
Posted Friday, May 15, 2009 6:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
Actually, it's the Resource database, with a capital R, not resource.
Post #717808
Posted Friday, May 15, 2009 6:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:42 AM
Points: 1,502, Visits: 2,672
This same QOD was posted a long time ago. . .
Post #717840
Posted Friday, May 15, 2009 7:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 7:20 PM
Points: 2,897, Visits: 5,978
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse