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 ?
In order to fail-over to the DR SQL SErver Log shipping will be helpful and depending upon the RESTORE TRANASACTION LOG job execution time you can set the timing, the general tendency would be log shipping every 15 minutes. For information on DR articles refer to thishttp://www.sql-server-performance.com/articles_other.asp article. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
