Post reply

Location of resource database ( SQL 2008 ONLY )

  • January 20, 2010 at 1:52 am

    #219721

    I've been presented with a clustered sql 2008 on win 2008; The default root install drive for data was defined as a shared drive.

    I've noticed that although all the system databases are where I expect them to be F:\MSSQL10.servername\MSSQL\DATA

    but the resource database is actually on the node local drive.

    I've researched as much as I can but can't seem to discover if this is intended - I'm pretty sure in SQL 2005 you had to have the master and resource database in the same location otherwise things could go wrong with patches/service packs.

    I'd note that it is actually the same on a non clustered install.

    Any views on this?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 20, 2010 at 2:01 am

    #1105891

    Quoted from MSDN -

    "<drive>:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\."

    I'll assume you are correct then, and also believe it must be in the same directory...but I could be wrong. 😉

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • January 20, 2010 at 4:41 am

    #1105944

    ah well not if you set the default locations during setup. In this case the Data Root Directory was set to the shared drive - this puts the system databases on the san, but the resource database ends up in program files on the local node.

    It seems then that the resource database is node dependant rather than cluster dependant - I don't have a sql2005 cluster to compare against sadly.

    I guess it's correct but I was looking for some type of confirmation.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 20, 2010 at 6:01 am

    #1105977

    The resource database on SQL 2008 is not stored with the other system databases. It's stored with the binaries, as if it were a dll or exe.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 21, 2010 at 6:36 am

    #1106645

    cool! That's what I figured, I just needed confirmation and couldn't seem to find it in msdn/technet/bol/setup.

    thanks.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 5 posts - 1 through 4 (of 4 total)

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