Re: Pros and Cons of using different replication methods for failover/disaster recovery

2008-01-31 Thread Hall Chad - chahal
We've used Log Shipping for almost 5 years now for our DR server. It works very well, but it has its quirks and it takes us at least 20 minutes to perform a failover. Also, if it gets out of synch on a big database plan on spending an entire day or more getting it synched back up. If you want I

Pros and Cons of using different replication methods for failover/disaster recovery

2008-01-25 Thread jmchugh
Hi All, Environment: ARS 7.0.x Windows 2003 ITSM 7.0.x Mid-Tier 7.0.x All on the same server. On an MS SQL Server 2000 or 2005, what are the pros and cons of using the following Replication methods for failover/disaster recover o Log Shipping o Snapshot Replication - may not cope with full