Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Active/Active Clustering

Author  Topic 

W00dY
Starting Member

8 Posts

Posted - 2008-11-13 : 10:07:04
I have a two node failover cluster, running 10 production databases. Is it possible to split the databases betweeen the nodes without compromising the failover capability?

Elisabeth Redei
Starting Member

15 Posts

Posted - 2008-11-15 : 10:49:21
Hi,

The unit of failover is the Virtual SQL Server (which corresponds to the group that contains the SQL Server svc, the SQL Server Agent svc, the Fulltext svc, IP address, Netname and some disks) - the cluster has no notion of the databases as such.

Are all your databases running in the same Virtual server (SQL server instance)? In that case you would have to install additional SQL Server Virtual servers and move your databases.


/Elisabeth



elisabeth@sqlserverland.com

Go to Top of Page
   

- Advertisement -