Location of database at sql server failover clustering

Hello there
If i set ewo nodes for sql server failover clustering, where does the
database is located?
See my reply to your other post in this group.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:ul8WfAh0HHA.4236@.TK2MSFTNGP06.phx.gbl...
Hello there
If i set ewo nodes for sql server failover clustering, where does the
database is located?
|||Whell Tom
I didn't understand where exacly the shared disk is: On node 1? on node 2?,
in a diffrent computer?
I didn't understand that from your explain. sorry.
Also what happen if node1 is being shut down?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eUo$TKj0HHA.5884@.TK2MSFTNGP02.phx.gbl...
> See my reply to your other post in this group.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:ul8WfAh0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> Hello there
> If i set ewo nodes for sql server failover clustering, where does the
> database is located?
>
|||On Mon, 30 Jul 2007 15:25:49 +0300, "Roy Goldhammer" <roy@.hotmail.com>
wrote:

>I didn't understand where exacly the shared disk is: On node 1? on node 2?,
>in a diffrent computer?
The shared disk is not in either computer, it is a box of disk drives
that is shared by BOTH computers. Both computers are connected to the
drives, but only one of them uses it at a time.
Roy Harvey
Beacon Falls, CT
|||Typically, the shared disks reside on a SAN - Storage Area Network. A
volume is carved out of the SAN and is presented to the cluster. Both nodes
have access, but only one at a time.
If NODE1 is being shut down, the clustered services running on NODE1
failover to NODE2 and begin running on there.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uDraDTq0HHA.5380@.TK2MSFTNGP04.phx.gbl...
Whell Tom
I didn't understand where exacly the shared disk is: On node 1? on node 2?,
in a diffrent computer?
I didn't understand that from your explain. sorry.
Also what happen if node1 is being shut down?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eUo$TKj0HHA.5884@.TK2MSFTNGP02.phx.gbl...
> See my reply to your other post in this group.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:ul8WfAh0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> Hello there
> If i set ewo nodes for sql server failover clustering, where does the
> database is located?
>