SQL Server Performance

Active/Active Clustering and Data refresh

Discussion in 'SQL Server 2005 Clustering' started by ramasubbup, Jul 25, 2006.

  1. ramasubbup New Member


    Is the possible to set up clustering as described below

    Set up SQL Server 2005 Cluster
    Install two instances of SQL Server in this cluster in which one
    will fail over the other
    First Instance will hold Staging Database where all my batch programs will run
    Second Instance will hold Production Database. The production database should
    be refreshed from the staging data daily
    To refresh the production data,I have the following options
    Use replication
    Log Shipping
    Custom Stored Procedures
    Database mirroring

    Please advice it is possible to do a these things
    What are the options which I have mentioned for refresing will work in active-active clustering?
  2. satya Moderator

    Why do you need cluster for this type of setup?
    You can use normal SQL server installation and use Replication or Log shipping to maintain the data integrity & consistency.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. ramasubbup New Member

    Yes. The client insists on Clustering setup

    The main thing I would like to know is
    is it possible to set up Replication/Logshipping between the clustered instances

Share This Page