MS SQL fail over/disaster recovery model.

[elcephus]

Hello all,

I am looking for the best practice to setup a SQL disaster recovery plan/redundancy in a remote location? Any good websites, book or other resources would be greatly appreacited.

 

[timscronin]

Is this real-time recovery? If so use log-shipping, MS and BOL have plenty of info. It's free with enterprise edition of sql server, easy to setup and to use

 

[elcephus]

No\Yes to real time recovery. Right now I'm looking for as much options as possible so that I could make better decision in the end. Any other suggestions would be great. Thanks.

 

[JayKusch]

Options are:

Clustering
Log Shipping

In SQL Server 2005 you will have a few more options like Database Snapshots and Mirroring if M$ can work some the the bugs out in it.

Thanks

J. Kusch