Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Arshad Ali » Administration
Add to briefcase
28 posts, Page 3 of 3
«««123

Administration Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Noel McKinney
Posted Saturday, May 16, 2009 2:22 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767
Amit Lohia (5/15/2009)
I have just install SQl 2008 and I do not see a resource database in system database? Do we need to install it?

You don't need to install the Resource database. It's already present but "hidden" so that you won't see it in obvious places, like under system databases in SQL Server Management Studio's Object Explorer or by querying sys.databases. If you want to access it then you might enjoy the following piece by Kalen Delaney:

http://sqlblog.com/blogs/kalen_delaney/archive/2007/09/13/geek-city-the-resource-database.aspx
Post #718555
John Esraelo-498130
Posted Saturday, May 16, 2009 2:54 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:10 PM
Points: 518, Visits: 920
FYI
I did run the select * from sys.databases and I got :
master
tempdb
model
msdb
reportserver$mssql2k8
reportserer$mssql2k8tempdb
and of course the other databases
..

Cheers,
John Esraelo
Post #718557
John Esraelo-498130
Posted Saturday, May 16, 2009 2:59 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:10 PM
Points: 518, Visits: 920
more on this topic..

this is also what I got from running the few lines in below:
use mssqlsystemresource
Msg 911, Level 16, State 1, Line 7
Database 'mssqlsystemresource' does not exist. Make sure that the name is entered correctly.

and..

SELECT id, name FROM master.sys.sysdbreg

Msg 208, Level 16, State 1, Line 2
Invalid object name 'master.sys.sysdbreg'.

Cheers,
John Esraelo
Post #718558
Noel McKinney
Posted Saturday, May 16, 2009 5:14 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767
John Esraelo (5/16/2009)
more on this topic..

this is also what I got from running the few lines in below:
use mssqlsystemresource
Msg 911, Level 16, State 1, Line 7
Database 'mssqlsystemresource' does not exist. Make sure that the name is entered correctly.

and..

SELECT id, name FROM master.sys.sysdbreg

Msg 208, Level 16, State 1, Line 2
Invalid object name 'master.sys.sysdbreg'.

The USE statement would require starting SQL Server in single user mode. The SELECT statement works when connected through the Dedicated Administrator Connection (DAC).

The SELECT queries in the last section of the following article don't require single user mode or DAC:

http://msdn.microsoft.com/en-us/library/ms190940.aspx
Post #718570
SanjayAttray
Posted Sunday, May 17, 2009 8:51 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: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554
Most amazing for me is looking at the results out of 953 attempts. If some one doesnot recognize ResourseDB as system database is Ok. May be they don't know but how can people have doubt about master, msdb, model and tempdb. They are part of SQL Server setup from ages ?

master 99%
msdb 97%
model 92%
tempdb 95%

SQL DBA.
Post #718771
Steve Jones - SSC Editor
Posted Sunday, May 17, 2009 9:19 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 5:39 AM
Points: 31,529, Visits: 13,866
It is amazing that they're all not 99%. I can see people mis-clicking things, so I'm not sure it will be 100%, but I'm surprised msdb isn't higher.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #718780
Noel McKinney
Posted Monday, May 18, 2009 6:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767
I'm not surprised. I've interviewed too many SQL Server "experts" and "experienced DBAs" (according to the placement firm that sent them) who couldn't name any of the system databases. When that happened I would say "ok, well one of them is tempdb, so can you name the others" just to get things moving forward, but that usually wouldn't help.
Post #718995
jts_2003
Posted Wednesday, May 20, 2009 9:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:56 AM
Points: 1,063, Visits: 4,261
Thanks for this quesion, as I has never heard of / noticed the Resource database before, so I now know to include backing it up as part of any major upgrade. Cheers, John.
Post #720707
« Prev Topic | Next Topic »

Add to briefcase
28 posts, Page 3 of 3
«««123

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.