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.


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.

  Podcast  

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

  • ABOUT THE AUTHOR:   
    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

    Dig deeper on SQL Server High Availability, Scalability and Reliability

    Pro+

    Features

    Enjoy the benefits of Pro+ membership, learn more and join.

    0 comments

    Oldest 

    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:

    -ADS BY GOOGLE

    This Content Component encountered an error
    Close