 |
|
|
Home > Podcast: Log shipping in SQL Server: Basics to best practices |
|
|
|
|
|
|
Podcast: Log shipping in SQL Server: Basics to best practices |
|
| 24 Jul 2007 | By Eric Johnson |
|
|
 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
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?
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.
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
| |
