HADR Tutorials for SQL Server in Windows Azure VMs

Hi Folks, For those interested in how to do SQL Server HADR in Windows Azure VMs, we have published a set of tutorials on Azure Documentation. A conceptual article gives you the overview for the subject and the tutorials show you how to set up specific scenarios end-to-end. The docs are currently in pre-release mode….

4

How To: Migrate to AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 2

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) This blog is the continuation of a blog series that shows you how to perform the following end-to-end HADR migration scenario of SQL Server inside a test environment: From a SQL Server 2008 R2 solution: Database mirroring for high availability and log shipping for…

0

How To: Migrate to AlwaysOn AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 1

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) This blog series is a follow-up to my whitepaper Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping. In this series, I will walk you through the following end-to-end migration scenario inside a test environment: From a…

4

Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping

Writer:Cephas Lin (Microsoft) Contributors: Sanjay Mishra (Microsoft) Technical Reviewers: Aditya Samant (Microsoft), Juergen Thomas (Microsoft), Prem Mehra (Microsoft), Charles Mathews (Microsoft), Jimmy May (Microsoft), David P. Smith (ServiceU) Content Program Manager: Glenn Minch (Microsoft)   Summary: This migration guide provides guidance for customers who have deployed database mirroring for local high availability and log shipping…

0

Add a Log Shipping Primary Database and Secondary Database(s) to an Existing Availability Group

Add a Log Shipping Primary Database and Secondary Database(s) to an Existing Availability Group by Margi Showman This blog is relevant if: (1) you have a log shipping primary database on the server instance that hosts the primary replica of an availability group, (2) at least one of the corresponding log shipping secondary database resides…

0

Converting a logshipping configuration to Availability Group

Converting Log Shipping Configurations to a New Availability Group Let’s take a scenario where you already have a log shipping configuration. You have three databases (db1, db2, and db3) that are set up for log shipping among three different data centers. The primary server for all three databases is AlwaysOn-srv1. The secondary servers are on…

2

AlwaysOn Availability Group and Database Mirroring

In SQL Server 2008 R2, a typical high availability deployment uses Database Mirroring to protect application databases from planned and unplanned downtime.  Database Mirroring combined with log shipping and failover clustering provide a great set of features that meet the high availability requirements of mission critical applications.   In Database Mirroring today, if the application is…

2