High availability

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.

AlwaysOn Secondaries

Database Mirroring

LogShipping

7 Things that High Availability is Not

Wesley has heard High Availablity touted as all sorts of technological cure-all for busy SysAdmins and DBAs, and now he's taking a stand against it. There are a range of things that High Availability is regularly confused with (either deliberately or innocently), and Wesley's clearing it all up

Windows Server 2008 Cluster feature

2005 High Availability Options

Using Partitioned Tables with Multiple Filegroups for High Availability

Let us look at another means to increase the availability of your highly critical databases. We will extend the concept of filegroups as highlighted in a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 2 (Isolating Critical Objects) wherein we can use filegroups to isolate and store a critical object.

SQL Server 2005 log shipping setup using the wizard

Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.