Post reply

Resource database - SQL Server 2008

  • February 11, 2011 at 1:28 am

    #231812

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

    Thanks

  • February 11, 2011 at 1:53 am

    #1285555

    I answered in haste and got it wrong

    M&M

  • February 11, 2011 at 2:07 am

    #1285557

    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.

  • February 11, 2011 at 2:09 am

    #1285559

    Nice and easy!

    (Easy because it was already asked in a previous QoTD some time ago :-D)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 11, 2011 at 4:03 am

    #1285595

    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

  • February 11, 2011 at 6:35 am

    #1285646

    Easy QOtD for Friday.

  • February 11, 2011 at 6:35 am

    #1285647

    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

  • February 11, 2011 at 6:43 am

    #1285650

    I still think, that it is possible. Or I just dont understand the Question.

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

  • February 11, 2011 at 6:52 am

    #1285657

    50-50 chance.

  • February 11, 2011 at 6:52 am

    #1285659

    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;

  • February 11, 2011 at 6:58 am

    #1285666

    Lady Di (2/11/2011)

    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;

    This is what I see in BOL:

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

    http://msdn.microsoft.com/en-us/library/ms345408(v=sql.100).aspx

    🙂

  • February 11, 2011 at 7:21 am

    #1285687

    I saw that in:

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

  • February 11, 2011 at 7:25 am

    #1285693

    Good question though I got it wrong. I thought i would be able to move the resource database in SQL Server 2008. After i got it wrong, i tried moving the resource data and log file in different drive and i was not able to start the sql server service then which proved that we cannot move the resource database to different drive. Good one and learnt a new lesson today. I am still not convinced though, if we could move other system databases, why we cannot move the resource database inSQL 2008?

    Thanks,

  • February 11, 2011 at 8:50 am

    #1285749

    Lady Di (2/11/2011)

    I saw that in:

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

    That URI indicates to me that you have help set up to use local help first. One of the major pitfalls of doing that is that if there are typos in the help system, they may be corrected online, but they won't get updated in your local copy, so you could be working from inaccurate information.

    I don't have local help to verify (I prefer not to use it for just that reason), but I believe that's what's happened here.

  • February 11, 2011 at 8:59 am

    #1285754

    Abi Chapagai (2/11/2011)

    Good question though I got it wrong. I thought i would be able to move the resource database in SQL Server 2008. After i got it wrong, i tried moving the resource data and log file in different drive and i was not able to start the sql server service then which proved that we cannot move the resource database to different drive. Good one and learnt a new lesson today. I am still not convinced though, if we could move other system databases, why we cannot move the resource database inSQL 2008?

    Thanks,

    The best answer I could find to that was here:

    http://www.sqldev.org/sql-server-setup--upgrade/moving-resource-database-in-sql-server-2008-doesnot-work-96677.shtml

    which shows that SQL Server 2008+ has a hardcoded process at startup that attaches the resource database from the same location as the executable file*, but doesn't explain why Microsoft has chosen to make it do that. I haven't seen a reason from Microsoft.

    *This implies that you may be able to move a resource database if you also move the SQL Server executable... any brave hearts with unimportant SQL 2008+ boxes want to try it? :w00t:

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

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