Set up a SQL Server disaster recovery site
We have two SQL Server 2000 servers set up for enabling clustering and there is a SAN attached. We want to set up a disaster recovery site away from the above primary site. Can we set up the disaster site with just one database server or do we need to replicate the same primary site setup? How do we set up log shipping?
In general, the answer is no. You can set up failover in several ways, be it replication, log shipping, database mirroring, or a third party tool. These are all database specific solutions that do not require the secondary hardware to be the same as the primary hardware. You can run your primary on a cluster and an offsite backup on a standalone SQL Server.
|Check out this helpful podcast: |
Log shipping in SQL Server: Basics to best practices|
SQL Server database administrator Eric Johnson explains how to back up your primary database and restore it to a secondary server through log shipping. He'll explain log shipping setup via SQL Server Management Studio. Get the details on how to set up multiple log shipping failover boxes to provide High Availability and a reliable reporting environment.
This was first published in October 2007