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?
Requires Free Membership to View
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: |
|
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
Join the conversationComment
Share
Comments
Results
Contribute to the conversation