System Databases

Question

Post reply

System Databases

Steve Jones - SSC Editor

SSC Guru

Points: 736162
More actions
January 8, 2009 at 11:17 pm

#75874

Comments posted to this topic are about the item System Databases

Viewing 15 posts - 1 through 15 (of 37 total)

You must be logged in to reply to this topic. Login to reply

Scott Herbert-214404 Old Hand Points: 387 More actions · Answer 1

there's a slight grammatical problem in this question.. "at"

ChiragNS One Orange Chip Points: 26137 More actions · Answer 2

ChiragNS

One Orange Chip

Points: 26137

January 9, 2009 at 1:10 am

#923959

Question not clear.

"Keep Trying"

jameslester78-958147 Old Hand Points: 342 More actions · Answer 3

i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 4

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/

D.Oc SSCrazy Points: 2875 More actions · Answer 5

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."

Dugi SSCoach Points: 17998 More actions · Answer 6

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/[/url]

Ben Leighton SSCommitted Points: 1838 More actions · Answer 7

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?

jameslester78-958147 Old Hand Points: 342 More actions · Answer 8

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

Dugi SSCoach Points: 17998 More actions · Answer 9

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/[/url]

William Vach SSCertifiable Points: 5537 More actions · Answer 10

I don't believe that you can move the mssqlsystemresource (resource) database. See the portion of the following article regarding moving the resource database: http://msdn.microsoft.com/en-us/library/ms345408.aspx

Ben Leighton SSCommitted Points: 1838 More actions · Answer 11

William Vach (1/9/2009)

I don't believe that you can move the mssqlsystemresource (resource) database. See the portion of the following article regarding moving the resource database: http://msdn.microsoft.com/en-us/library/ms345408.aspx%5B/quote%5D

looks like that answers my question! Thanks. Clearly moving the sysresource db in 2005 was such a disaster that the boffins have stopped it happening in 2008. Hooray!

HanShi SSC-Dedicated Points: 33507 More actions · Answer 12

William Vach (1/9/2009)
I don't believe that you can move the mssqlsystemresource (resource) database.

I agree with William: I thought the question is which system databases can be moved. Therfor I didn't select mssqlsystemresource. But the question is not very clear because of the grammar error "... of the following at system ..."

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

MeherM Hall of Fame Points: 3072 More actions · Answer 13

Yes the answers are wrong. we cannot move the mssqlsystemreource database in SQL Server 2008. The default location is \Binn\.

Ref: http://msdn.microsoft.com/en-us/library/ms345408.aspx

SanjayAttray SSChampion Points: 13157 More actions · Answer 14

Don't know about 2008 but once tried to move mssqlsystemresource database in SQL server 2005 and all hell broke for me. Have to install and configure complete server again.

With last experience I would never again dare to touch this database for move, even in 2008.

SQL DBA.