Resource database - SQL Server 2008

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

    Thanks

  • I answered in haste and got it wrong

    M&M

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

  • 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

  • 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

  • Easy QOtD for Friday.

  • 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

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

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

  • 50-50 chance.

  • 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;

  • 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

    🙂

  • I saw that in:

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

  • 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,

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

  • 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