SQL Server Performance

Databases in a Cluster

Discussion in 'SQL Server Clustering' started by krajdba, Apr 24, 2007.

  1. krajdba New Member

    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

  2. satya Moderator

    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
    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.

Share This Page