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, September 9, 2010 6:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:42 PM
Points: 10,193, Visits: 13,120
I also got this wrong by selecting none, but only because I am using SQL Server 2005 and was aware that the resource database location was/is dependent on the location of the master database. Since others have mentioned the change in 2008 I accept that I was wrong for the latest release of SQL Server.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #983021
Posted Thursday, September 9, 2010 7:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Yes, me too worng....

The correct answer is none. As though resource database is readonly we can move it along with master.

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


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #983053
Posted Thursday, September 9, 2010 7:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334, Visits: 3,069
free_mascot (9/9/2010)
Yes, me too worng....

The correct answer is none. As though resource database is readonly we can move it along with master.

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


In SQL Server 2008, the Resource database cannot be moved, Your provided link clearly states that.


"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #983088
Posted Thursday, September 9, 2010 8:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 12,956, Visits: 10,727
TravisDBA (9/9/2010)
free_mascot (9/9/2010)
Yes, me too worng....

The correct answer is none. As though resource database is readonly we can move it along with master.

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


In SQL Server 2008, the Resource database cannot be moved, Your provided link clearly states that.


Unfortunately, your question didn't




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #983137
Posted Thursday, September 9, 2010 8:33 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: Wednesday, September 17, 2014 5:54 AM
Points: 554, Visits: 1,197
Funny, I initially chose the Resource database cannot be moved, but then after checking my local BOL I changed to all can be moved. If you check the online BOL it shows it cannot be moved in SQL 2008 and 2008 R2. Although, I wonder if it really can be moved in 2008 (non R2) considering the inconsistent documentation.

From my local BOL ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/72bb62ee-9602-4f71-be51-c466c1670878.htm


Moving the Resource Database
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.
Post #983148
Posted Thursday, September 9, 2010 8:39 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:09 PM
Points: 17,628, Visits: 15,487
Thanks for the Question. I was debating internally whether it was 2005 or 2008. I decided to go with 2008.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #983161
Posted Thursday, September 9, 2010 8:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334, Visits: 3,069
da-zero (9/9/2010)
TravisDBA (9/9/2010)
free_mascot (9/9/2010)
Yes, me too worng....

The correct answer is none. As though resource database is readonly we can move it along with master.

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


In SQL Server 2008, the Resource database cannot be moved, Your provided link clearly states that.


Unfortunately, your question didn't


Reading is fundamental. I already stated in a previous post in this thread that I had omitted the version, and that was my bad, but the answer is correct for SQL 2008.


"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #983187
Posted Thursday, September 9, 2010 9:19 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 9:42 PM
Points: 31,036, Visits: 15,466
I have corrected the question to say that it is for SQL Server 2008 R2 (using the latest reference), noted that it can be moved in 2005, and then awarded back points for everyone.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #983218
Posted Thursday, September 9, 2010 10:26 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:09 PM
Points: 17,628, Visits: 15,487
Steve Jones - Editor (9/9/2010)
I have corrected the question to say that it is for SQL Server 2008 R2 (using the latest reference), noted that it can be moved in 2005, and then awarded back points for everyone.


How kind.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #983285
Posted Thursday, September 9, 2010 2:00 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334, Visits: 3,069
Thanks Steve.

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #983414
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse