Resource database - SQL Server 2008

  • Hardy21

    SSCrazy Eights

    Points: 9708

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

    Thanks

  • M&M

    SSC-Insane

    Points: 21699

    I answered in haste and got it wrong

    M&M

  • InvisibleCat

    Default port

    Points: 1496

    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.

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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

  • M&S maf

    Old Hand

    Points: 308

    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

  • paul s-306273

    SSChampion

    Points: 10615

    Easy QOtD for Friday.

  • JestersGrind

    SSCertifiable

    Points: 5439

    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

  • Jaroslav Pfauser

    SSC Eights!

    Points: 826

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

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

  • OCTom

    SSChampion

    Points: 11755

    50-50 chance.

  • Lady Di

    Hall of Fame

    Points: 3337

    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;

  • OCTom

    SSChampion

    Points: 11755

    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

    🙂

  • Lady Di

    Hall of Fame

    Points: 3337

    I saw that in:

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

  • Abi Chapagai

    SSCrazy

    Points: 2666

    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,

  • sknox

    SSChampion

    Points: 12292

    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.

  • sknox

    SSChampion

    Points: 12292

    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 35 total)

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