Home > Ask the SQL Server Experts > Eric Johnson - SQL Server 2005 and Reporting Services Questions & Answers > Set up a SQL Server disaster recovery site
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Set up a SQL Server disaster recovery site

Eric Johnson EXPERT RESPONSE FROM: Eric Johnson

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 17 October 2007
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?

>
EXPERT RESPONSE
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.

  • Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


    RELATED CONTENT
    SQL Server backup and recovery
    SQL Server backups using SAN database snapshots
    Tips for scheduling and testing SQL Server backups
    Code to restore SQL Server databases in VB.NET
    Tricking SQL Server into making full database backups
    SAN considerations for your SQL Server environment
    Top 7 SQL Server backup and restore tips of 2007
    Retrieve deleted tables in SQL Server
    SQL Server backup and restore commands to limit downtime
    Mirrored backup and restore commands in SQL Server 2005
    Best practices for SQL Server backup maintenance
    SQL Server backup and recovery Research

    Eric Johnson - SQL Server 2005 and Reporting Services
    How to insert into SQL Server system tables
    Installing SQL Server native client
    Deploy reports from Reporting Services on webpage
    Connect to SQL Server database with Visual Basics
    Run SSRS with SQL Server Business Intelligence Development Studio
    Just installed SQL Server 2005 Express can't find database
    Migrating SQL Server applications after upgrade

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    rollback  (SearchSQLServer.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary



    Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice

    HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




    All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts