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

Resource database - SQL Server 2008 Expand / Collapse
Author
Message
Posted Friday, February 11, 2011 1:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 5:13 AM
Points: 1,131, Visits: 1,394
Comments posted to this topic are about the item Resource database - SQL Server 2008

Thanks
Post #1062395
Posted Friday, February 11, 2011 1:53 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
I answered in haste and got it wrong

Mohammed Moinudheen
Post #1062400
Posted Friday, February 11, 2011 2:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 11, 2013 8:39 AM
Points: 58, Visits: 606
mohammed moinudheen (2/11/2011)
I answered in haste and got it wrong



It must be catching, because I knew the answer, yet clicked yes anyway. Friday mornings hey! It's been a long week.
Post #1062402
Posted Friday, February 11, 2011 2:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
Nice and easy!
(Easy because it was already asked in a previous QoTD some time ago )




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 #1062404
Posted Friday, February 11, 2011 4:03 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, July 10, 2014 3:31 AM
Points: 135, Visits: 157
Why was it possible to move the DB in 2005 whereas in 2008 its not possible anymore?

I never had to do it and I never thought about doing it, I am just curious why it has changed.

Thanks in advance

EDIT:
From the BOL:

Moving the Resource Database

In SQL Server 2008, the location of the Resource database is <drive>:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\. The database cannot be moved


But it does not say why I am not able to move it
Post #1062450
Posted Friday, February 11, 2011 6:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 24, 2014 5:46 AM
Points: 1,416, Visits: 804
Easy QOtD for Friday.
Post #1062517
Posted Friday, February 11, 2011 6:35 AM


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: Tuesday, May 14, 2013 1:42 PM
Points: 3,487, Visits: 1,581
Yes, it was possible to move the resource database in SQL2005.

http://msdn.microsoft.com/en-us/library/ms345408%28v=SQL.90%29.aspx

Thanks,

Greg




Post #1062519
Posted Friday, February 11, 2011 6:43 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, April 8, 2013 8:13 AM
Points: 700, Visits: 100
I still think, that it is possible. Or I just dont understand the Question.

http://msdn.microsoft.com/en-us/library/ms190940.aspx
Post #1062522
Posted Friday, February 11, 2011 6:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:14 PM
Points: 2,627, Visits: 4,026
50-50 chance.
Post #1062529
Posted Friday, February 11, 2011 6:52 AM
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: Wednesday, September 24, 2014 10:23 AM
Points: 3,241, Visits: 140
In SQL Server 2008 BOL you can read this:

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;
Post #1062531
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse