Ask the Expert

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?

    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:   
  • 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

    There are Comments. Add yours.

     
    TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

    REGISTER or login:

    Forgot Password?
    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
    Sort by: OldestNewest

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to: