|SQL Server replication|
In this podcast, you'll grasp the functionality of replication and what it can do for your SQL Server environment. SQL Server database administrator Eric Johnson starts by explaining the three replication types: snapshot, transactional and merge. He then takes you through setting up replication for high availability and outlines how to failover a replication solution.
|Database mirroring in SQL Server|
Database mirroring in SQL Server 2005 will increase your system's availability by allowing a quick and automatic failover. Learn about the three SQL Server instances: principal, mirror and witness. SQL Server expert Eric Johnson shares the types of mirroring solutions for high availability and how to configure those solutions.
|Log shipping in SQL Server|
Get instructions for setting up log shipping via SQL Server Management Studio. Then you can back up your primary database and restore it to a secondary server through log shipping. You'll get those details along with how to set up multiple log shipping failover boxes to provide high availability and a reliable reporting environment.
|Related tips and guides:|
|ABOUT THE AUTHOR:|
|Eric Johnson (MCSE, MCITP: Database Administrator, MCSD) is a 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. He has presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. Eric is active in the local SQL Server Community, serving as the president of the Colorado Springs SQL Server Users Group.|
This was first published in August 2007