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 and how to best utilize the standby server for failover and for read-only data. Lastly, get the details on how and why to set up multiple log shipping failover boxes to provide High Availability and a reliable reporting environment.


  • Download the podcast: Log shipping in SQL Server – Basics to best practices

  •   Podcast highlights 

  • Total run time: 9.40

  • (0.50) What is log shipping?

  • (2.20) How is log shipping set up?

  • (3.58) How do you failover to the standby server?

  • (5.24) Can you use the standby server for anything besides failover?

  • (7.48) Can you log ship to more than one secondary server?

  •   Related tips and guides:  

  • Log shipping in SQL Server 2000 provides auto failover: Log shipping in SQL Server 2000 does not feature the built-in automatic failover. But follow this method and have log shipping available to you.
  • Disaster recovery features in SQL Server 2005: New backup and restore features in SQL Server 2005 include log shipping, replication and database mirroring. Know your best option for disaster recovery.
  • Setting up and maintaining standby servers: Standby servers may be used for continuous log shipping in the event of a database failure or to verify SQL Server backups. Here you'll find tips for setting up and maintaining a standby server.

    Eric Johnson (MCSE, MCITP: Database Administrator, MCSD) is co-founder of Consortio Services and the primary Database Technologies Consultant. He has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. Eric has presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. He is president of the Colorado Springs SQL Server Users Group.

    This was first published in July 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: