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 Saturday, May 16, 2009 2:22 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
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
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: Wednesday, January 22, 2014 2:58 PM
Points: 531, Visits: 965
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
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: Wednesday, January 22, 2014 2:58 PM
Points: 531, Visits: 965
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
Posted Saturday, May 16, 2009 5:14 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
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
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: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
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
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 @ 3:11 PM
Points: 31,368, Visits: 15,837
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
Posted Monday, May 18, 2009 6:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 4:12 PM
Points: 2,007, Visits: 768
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
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: Tuesday, December 16, 2014 5:26 AM
Points: 1,120, Visits: 4,909
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 «««123

Permissions Expand / Collapse