SQL Server Performance Forum – Threads Archive
Databases in a Cluster
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 consideredin failover situation?
Thanks & Regards
raj
Clustering is server based high availability solution, as it doesn’t see or know about databases. It provides the option for SQL Server services and other services on Windows operating system, if you are looking for per database solution then go for Database mirroring in SQL 2005 which has this feature. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>