Dear Ekrem
kindly explain me, if I make an active/active cluster, then after that if I
want to create a Databases.
tell me where these files of Database will reside, on Shared Disk or local
drives ? and if it is on
shared disk, will it be available to both nodes at the same time or just to
one active node and then to
other node at the time of failover.
I'm clear about active/passive as you told about active/passive that only
one setup of SQL reisdes on shared disk and also the database files on shared
disk.
Regards
--
DBA

Hello there!

Database files are definitely be located at the Shared Disks.

In a more-than-one-active-node cluster (which is Active\Active) there should
be at least two Shared Disks. At least one for each active node.

For example you want your users to use DB1 for Node1 then you'll locate
these database's files to the Shared Disks of Node1. If you have another
DB2, then locate it's database files on Shared Disks of Node2.

A Shared Disk may only be owned by only one particular Node at a time. A
Shared Disk can not be used by two or more nodes at the same time. This
brings consistency.

The reason you put your database files on your Shared Disks is, when your
Node1 would get broken, then your Shared Disk resources would be owned by
another Node in your Cluster. So, your database files would still be used by
your users. If you'd locate your database files on your local disk drives,
then when your Node1 breaks down, then your database files would not be
usable. That's why people use Disk Storage Systems that is a seperate part
from your particular servers. Those Storage Systems would still be used when
your Nodes break down. So your database files too.

I hope I'm clear here?

Additional Info:
You may use your local disks for Quorum Disk purpuses only if you set your
Quorum Disk system as Majority Node Set. However, you'd do this when you
have more than 2 nodes in your Cluster.

Also, you'll use your local disks to locate the binary files of SQL Server
and your Operating System etc.

--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITPBA, MCSD.Net, MCSE, MCT



"SQLWay" <SQLWay@discussions.microsoft.com> wrote in message
news:705E3A05-F75D-467C-80BF-F9A860147F4F@microsoft.com...
> Dear Ekrem
> kindly explain me, if I make an active/active cluster, then after that if
> I
> want to create a Databases.
> tell me where these files of Database will reside, on Shared Disk or local
> drives ? and if it is on
> shared disk, will it be available to both nodes at the same time or just
> to
> one active node and then to
> other node at the time of failover.
> I'm clear about active/passive as you told about active/passive that only
> one setup of SQL reisdes on shared disk and also the database files on
> shared
> disk.
> Regards
> --
> DBA