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.
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. /Elisabethelisabeth@sqlserverland.com |
|
|
|
|
|