SQL Server Performance

Disaster recovery

Discussion in 'SQL Server Log Shipping' started by anilkumarbb, Jul 25, 2004.

  1. anilkumarbb New Member

    What is the minimum time delay can be set for transaction log backup and restore on standby ?

    I am logging forward to achive the below envirnoment

    There is a need for database recovery (scenario is a below)

    MTS __R__ RQS
    |____R___ MTS1 (Disaster)

    R ---- Replication

    Data should be replicated from MTS to both MTS1(Disaster) and RQS as showed above (which should include identity, primary key, constraint and non constraint columns).
    On failure of MTS, we should be able to use MTS1 database form there on.

    Please can anyone suggest how this can be achieved ?
  2. satya Moderator

Share This Page