There have never been more ways to connect with customers—and it’s never been more challenging.
That’s why forward-thinking companies are integrating data across channels. And they’re doing it
now... Page 12
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.
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.