Resource database - SQL Server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Hardik Doshi » Resource database - SQL Server 2008

35 posts, Page 1 of 4

1 2 3 4 »»»

Resource database - SQL Server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

Hardy21

Posted Friday, February 11, 2011 1:28 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 7:11 AM
Points: 877, Visits: 1,159

Comments posted to this topic are about the item Resource database - SQL Server 2008

Thanks

Post #1062395

mohammed moinudheen

Posted Friday, February 11, 2011 1:53 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:43 PM
Points: 2,174, Visits: 3,586

I answered in haste and got it wrong

Mohammed Moinudheen

Post #1062400

Nic-306421

Posted Friday, February 11, 2011 2:07 AM

Valued Member

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:31 AM
Points: 58, Visits: 540

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

Koen Verbeeck

Posted Friday, February 11, 2011 2:09 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

Nice and easy!
(Easy because it was already asked in a previous QoTD some time ago BigGrin

)

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

MartySQL

Posted Friday, February 11, 2011 4:03 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 5:13 AM
Points: 135, Visits: 145

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

paul s-306273

Posted Friday, February 11, 2011 6:35 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,161, Visits: 642

Easy QOtD for Friday.

Post #1062517

JestersGrind

Posted Friday, February 11, 2011 6:35 AM

Hall 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

Jaroslav Pfauser

Posted Friday, February 11, 2011 6:43 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, April 08, 2013 8:13 AM
Points: 692, 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

OCTom

Posted Friday, February 11, 2011 6:52 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:52 AM
Points: 2,018, Visits: 2,852

50-50 chance.

Post #1062529

Lady Di

Posted Friday, February 11, 2011 6:52 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 12:06 PM
Points: 2,712, Visits: 133

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 »

35 posts, Page 1 of 4

1 2 3 4 »»»

Permissions