January 20, 2010 at 1:52 am
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
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
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
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
January 21, 2010 at 6:36 am
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