SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


System Databases


System Databases

Author
Message
TravisDBA
TravisDBA
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1990 Visits: 3069
Comments posted to this topic are about the item System Databases

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
UMG Developer
UMG Developer
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2688 Visits: 2204
Nice question thanks!

I think it would have been more challenging if it has been multiple choice...
Hugo Kornelis
Hugo Kornelis
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11020 Visits: 11994
Good question. Too bad you did not include a reference in the explanation.
For those who want to double check (and to see HOW those system databases can be moved), here is a reference: http://msdn.microsoft.com/en-us/library/ms345408.aspx


UMG Developer (9/8/2010)
I think it would have been more challenging if it has been multiple choice...

True. But it is, unfortunately, not possible to submit a question with only one correct answer as a multiple choice question. The software automatically decides on single choice vs multiple choice based on the number of correct answers.


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
vk-kirov
vk-kirov
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3710 Visits: 4408
The Resource database is a read-only database that contains all the system objects that are included with SQL Server ... So, the Resource db cannot be moved.

Sorry, but this conclusion is wrong. In SQL Server 2005, the Resource database can be moved along with the master database: http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx. In SQL Server 2008, the Resource database cannot be moved (as I think) just by design.

Good question, anyway.
Sequelsurfer
Sequelsurfer
Mr or Mrs. 500
Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)

Group: General Forum Members
Points: 522 Visits: 1327
Got caught out by this question because I knew I had moved the Resource database at some point in the past. Had to have been SQL 2005 though as has been correctly pointed out it is fixed in SQL 2008.
Chris Houghton
Chris Houghton
Say Hey Kid
Say Hey Kid (694 reputation)Say Hey Kid (694 reputation)Say Hey Kid (694 reputation)Say Hey Kid (694 reputation)Say Hey Kid (694 reputation)Say Hey Kid (694 reputation)Say Hey Kid (694 reputation)Say Hey Kid (694 reputation)

Group: General Forum Members
Points: 694 Visits: 1695
vk-kirov (9/9/2010)
The Resource database is a read-only database that contains all the system objects that are included with SQL Server ... So, the Resource db cannot be moved.

Sorry, but this conclusion is wrong. In SQL Server 2005, the Resource database can be moved along with the master database: http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx. In SQL Server 2008, the Resource database cannot be moved (as I think) just by design.

Good question, anyway.


Agreed. I have moved the resource database when relocating the master database in SQL Server 2005. I suspected that I'd be marked wrong on this question for selecting the "NONE" option
chris.reynolds
chris.reynolds
SSC Journeyman
SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)

Group: General Forum Members
Points: 90 Visits: 77
Interesting question:

SQL 2008 help says you can:

In SQL Server 2008, the default location of the Resource database is <drive>:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\Binn\. The database can be moved; however, we recommend against moving it for two reasons:

Applying SQL Server service packs and hotfixes restores the database to the \Binn location.


Moving the Resource database in a failover cluster environment to a nonclustered location will cause failover cluster failure.


To move the Resource database, follow these steps.



which, I guess is superceded by the KB mentioned above.

http://msdn.microsoft.com/en-us/library/ms345408.aspx
Michael Riemer
Michael Riemer
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2838 Visits: 639
Great question, and interesting feedback as always- Thanks all
cengland0
cengland0
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1682 Visits: 1300
Hugo Kornelis (9/9/2010)
Good question. Too bad you did not include a reference in the explanation.
For those who want to double check (and to see HOW those system databases can be moved), here is a reference: http://msdn.microsoft.com/en-us/library/ms345408.aspx


UMG Developer (9/8/2010)
I think it would have been more challenging if it has been multiple choice...

True. But it is, unfortunately, not possible to submit a question with only one correct answer as a multiple choice question. The software automatically decides on single choice vs multiple choice based on the number of correct answers.


Agreed too. I believe the correct answer should have been "None of these" because they can all be moved. I got it wrong but I still believe I selected the correct answer.

According to Microsoft:
For information about how to move the master data and log files, see Moving System Databases. The Resource database depends on the location of the master database. If you move the master database, you must also move the Resource database to the same location.

This is found on the following page: http://msdn.microsoft.com/en-us/library/ms187837.aspx
coltuszyk
coltuszyk
SSC Veteran
SSC Veteran (251 reputation)SSC Veteran (251 reputation)SSC Veteran (251 reputation)SSC Veteran (251 reputation)SSC Veteran (251 reputation)SSC Veteran (251 reputation)SSC Veteran (251 reputation)SSC Veteran (251 reputation)

Group: General Forum Members
Points: 251 Visits: 140
http://decipherinfosys.wordpress.com/2009/02/12/moving-the-resource-database-in-sql-server-2005/

A QUICK HOW-TO GUIDE if you want move resource database in SQL 2005 Hehe

-------------------------------
www: 3CityDBA.pl
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search