clustering - SQL Server clustering Vs Veritas Clustering

Discussion in 'microsoft.public.sqlserver.server' started by RK73, Jul 28, 2005.

  1. RK73

    RK73 Guest

    We would like to go for clustering. Does anybody have recomendations on
    Veritas clustering versus SQL server clustiring (i.e. SQL server clustering
    on top of Windows clustering)

    RK73, Jul 28, 2005
    1. Advertisements

  2. Short version:
    MS Clustering Yes. Veritas Clustering NO.

    Veritas doesn't quite have the transparent failover thing working. MS uses
    a virtual server concept so the SQL instance is completely host independent.
    Veritas thinks they have that but there some areas, especially related to
    SQL Server Agent and the server name, that just don't quite work as you
    would expect. Veritas is a lot closer to the SQL 7.0 clustering model than
    to SQL 2000. I.E. a primary node has a "partner" node that takes over in
    the event of failure. SQL 2000 runs pretty much host node independent
    except for install and upgrade tasks and then you only need to identify the
    current host, not the original host.

    To be fair, it has been a while since I did anything with Veritas clustering
    so it may have gotten better. I am certain that Windows Clustering has
    improved with Windows Server 2003.

    Geoff N. Hiten
    Senior Database Administrator
    Microsoft SQL Server MVP
    Geoff N. Hiten, Jul 29, 2005
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.