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

System Databases Expand / Collapse
Author
Message
Posted Thursday, January 8, 2009 11:17 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 10:12 AM
Points: 31,210, Visits: 15,651
Comments posted to this topic are about the item System Databases






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #633104
Posted Friday, January 9, 2009 12:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, February 16, 2014 6:02 PM
Points: 177, Visits: 242
there's a slight grammatical problem in this question.. "at"
Post #633120
Posted Friday, January 9, 2009 1:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
Question not clear.

"Keep Trying"
Post #633152
Posted Friday, January 9, 2009 1:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 29, 2012 7:22 AM
Points: 24, Visits: 161
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.
Post #633168
Posted Friday, January 9, 2009 2:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:13 AM
Points: 2,119, Visits: 5,520
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.


Actually the mssqlsystemresource was introduced at SQL Server 2005

Adi



--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #633171
Posted Friday, January 9, 2009 2:19 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: Monday, March 17, 2014 6:21 AM
Points: 997, Visits: 6,477
I'm not sure why I thought Resource Database is not a part of System DB???

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."


Post #633174
Posted Friday, January 9, 2009 2:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 2:32 AM
Points: 1,260, Visits: 3,423
Adi Cohn (1/9/2009)
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.


Actually the mssqlsystemresource was introduced at SQL Server 2005

Adi



Yes the system databases in SQL Server 2005 are

master
msdb
model
tempdb
Resource Database = mssqlsystemresource!

So the user just see the information about Resource Database, not also that this resource db name is "mssqlsystemresource"
Anyway the Resource Database is a read-only database that contains system objects that are included with SQL Server. System objects are physically persisted in the Resource database, but they logically appear in the sys schema of every database.


============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #633178
Posted Friday, January 9, 2009 2:57 AM
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: Tuesday, July 5, 2011 8:18 AM
Points: 582, Visits: 359
hmmm... just going slightly off piste here but that mssqlsystemresource db has been a constant source of irritation for me... especially where the log and mdb have been installed on different drives to their default sql server location... In 2005 for some reason whenever a service pack is installed it bugs right up... I wonder whether the same will happen with 2008?
Post #633201
Posted Friday, January 9, 2009 4:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 29, 2012 7:22 AM
Points: 24, Visits: 161
Adi Cohn (1/9/2009)
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.


Actually the mssqlsystemresource was introduced at SQL Server 2005

Adi



oh, when i look in my system databases folder all I see are master, model, msdb and tempdb
Post #633251
Posted Friday, January 9, 2009 5:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 2:32 AM
Points: 1,260, Visits: 3,423
jameslester78 (1/9/2009)
Adi Cohn (1/9/2009)
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.


Actually the mssqlsystemresource was introduced at SQL Server 2005

Adi



oh, when i look in my system databases folder all I see are master, model, msdb and tempdb


In SQL Server 2005

+1 Resource Database see BOL for more infos!...


============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #633264
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse