Re: mount points help urgent

Tech-Archive recommends: Fix windows errors by optimizing your registry

If the mounted volume depends on the root drive, and SQL Server depends on
the mounted volume, then why would you make SQL Server also dependent on the
root drive?

SQL Server depends on the Network Name, which depends on the IP address.
Would you also make SQL Server dependent on the IP address?

I'm just trying to get an idea for the basis of your claim. The only
circumstance for which I would make SQL Server also dependent on the root
drive is if SQL Server also stored data on the root, not just the mounted
volume.


Anthony Thomas


--

"Edwin vMierlo" <EdwinvMierlo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:e0pL0oSEHHA.4508@xxxxxxxxxxxxxxxxxxxxxxx

"Anthony Thomas" <ALThomas@xxxxxxxxx> wrote in message
news:%23YQ4LCLEHHA.996@xxxxxxxxxxxxxxxxxxxxxxx
Agreed. I'm surprised that it doesn't. And, if you follow the best
practices of resource dependencies, SQL Server should depend on the
mounted
volume, mounted volume depends on mounted physical drive, and SQL Server
DOES NOT depend on physical drive letter,

I would still make SQL server depend on the mounted physical (root) drive
letter.


any more than it depends on IP
(because it depends on Network Name, which depends on IP).

I'm surprised this same arrangement was not followed, which begs the
question on how much thought really went into the design.

For all of it wonderful features, I am becoming less confident in the
core
design more and more.

They had over 5 years to work on this for Pete's sake.


Anthony Thomas


--

"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2AEC7B4F-28C8-42CE-9AD2-FE19E4663149@xxxxxxxxxxxxxxxx
"Anthony Thomas" wrote:

Mounted volumes still have to be mounted to an assigned drive letter
volume.
SQL Server still has to depend on this drive letter.


Quite true. In fact, a mounted volujme should depend on the root
drive.
But
the SQL Server 2005 resource doesn't have to depend the mounted volume
(although it probably should).

Linchi


--

"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:D24BAF11-4962-4C2D-9DE9-84F0F9C7A984@xxxxxxxxxxxxxxxx
Does sql need to be dependant on any of the disks?

For some unknown reason, the SQL Server resource does not have to
depend
on
a mounted volume when you place a database file on that mounted
volume.
This
is different from the behavior with a drive letter. This also
means
that
you
can take that mounted volume offline, thus taking the database on
it
offline,
without affecting the resource group. In most cases, this would
not
make
much
sense. After all you go through trouble to create a cluster for
HA.
So,
I'd
suggest that you still add the dependency so that the SQL Server
resource
does depend on any used mounted volume.

Linchi

"mapleleaf" wrote:


I know how to create mount point in windows 20003 cluster, I am
not
sure
how
to set it up with SQL 2005 running on the cluster.
Does sql need to be dependant on any of the disks? I have tried
looking for
a guide, but cannot find.

current setup active active cluster running. I need to add san
space
which
will hold the databases. The san will be carved up into drive
letters.
each
drive letter will hold 3 mount points.
ie.
node 1
J:-2 mount point
k:2 mount point
l:2 mount point

node 2-
r:-2 mount point
s:2 mount point
t:2 mount point

each node would be able to own the disk if the other node failed
over.

any help is appreciate. I have tried books online etc.. cannot
find
a
good
step by step.;


--
mapleleaf


------------------------------------------------------------------------
mapleleaf's Profile: http://www.dbtalk.net/m624
View this thread: http://www.dbtalk.net/t346064











.

Relevant Pages

  • Re: mount points help urgent
    ... smart that it does not necessarily have to depend on the mount, ... SQL Server depends on the Network Name, which depends on the IP address. ... Would you also make SQL Server dependent on the IP address? ... the SQL Server resource does not have ...
    (microsoft.public.sqlserver.clustering)
  • Re: Indexed View Crashes ASP.NET App
    ... to the root tables. ... Since you do not include which version of SQL Server you are using, ... The first two are saved with stored procedures, ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: mount points help urgent
    ... IF you are 100% certain that SQL has no data in the root ... SQL Server depends on the Network Name, which depends on the IP address. ... I know how to create mount point in windows 20003 cluster, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Website navigation hierarchy with SQL Server 2005
    ... declare @root int; ... WHERE ParentNodeId IS NULL ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: for auto question
    ... Note that FOR XML in SQL Server 2005 is adding a ROOT directive. ... > property of the ADO command object, the RootTag property of the ADO.NET ...
    (microsoft.public.sqlserver.xml)