90 Databases on cluster (Active/Passive)

hello, I am going to install SQL Server 2000 on Windows2003 server with
(Active/Passive) configuration
I have db space as 600 gig , ranges 1 gb to 90 gb. i have one concern about
how log failover to passive server will take in case of it need? whether it
depend on the db size or file group configuration of sql server? what about
the transactions in case of failover time? is there any way we have to
configure cluster for 100% transactions accuracy. i am using IIS6.0 as web
server for my online store.
Thanks for impromptu in advance.
John
Active-Passive is an obsolete term. You are building a single-instance,
two-node cluster. Under SQL Server 2000, all cluster nodes are treated
equally after initial installation. A single SQL instance can live on any
cluster node, but only on one node at a time.
Think of a cluster failover as a SQL Service stop-restart event. Everything
that happens during a server restart, happens during a failover. All
non-committed transactions are rolled back, committed transactions are
rolled forward. Transactional consistency is still guaranteed. Actual
recovery time is affected by the number of databases to recover and the
number/size of active transactions.
As for transactions log behavior during a failover, all SQL data and log
files must be stored on a cluster resource so they can be assigned to any
host node. The cluster service and the SQL cluster configuration guarantee
all resources go to a particular host node together so the SQL server can
run.
Geoff N. Hiten
Microsoft SQL Server MVP
"John" <John@.discussions.microsoft.com> wrote in message
news:598594BE-EAA6-4727-A56E-CF9DA9D8FB09@.microsoft.com...
> hello, I am going to install SQL Server 2000 on Windows2003 server with
> (Active/Passive) configuration
> I have db space as 600 gig , ranges 1 gb to 90 gb. i have one concern
> about
> how log failover to passive server will take in case of it need? whether
> it
> depend on the db size or file group configuration of sql server? what
> about
> the transactions in case of failover time? is there any way we have to
> configure cluster for 100% transactions accuracy. i am using IIS6.0 as web
> server for my online store.
> Thanks for impromptu in advance.
> John
>