Databases in a Cluster - SQL Server Forums

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 2005 Forums

High Availability (2005)

Databases in a Cluster

Author

Topic

krajdba
Starting Member

43 Posts

Posted - 2007-04-24 : 08:37:49

Hi Gurus,

I have a Active/Active Cluster namely Node1 and Node2. Can I tell MS SQL Server 2000 What/which databases (not all databases) in NODE1 will be considered
in failover situation?

Thanks & Regards

Raj.

SatyaSKJ
Starting Member

46 Posts

Posted - 2007-04-24 : 09:32:17

SQL Server Cluster is meant to for server based high availability solution and for databases you might take help of database mirroring.
In Cluster you cannot specify to look for a database, only services on the windows server can be specified.

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-24 : 09:50:48

All sql instances you installed on the cluster should be able to do failover.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources