Clustering

External Article

Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

  • Article

This paper provides guidance for customers who prior to SQL Server 2012 have deployed SQL Failover Clustering for local high availability and database mirroring for disaster recovery, and who want to migrate to SQL Server AlwaysOn. It describes the corresponding SQL Server AlwaysOn scenario and the migration paths to SQL Server AlwaysOn. It also contains the important knowledge and considerations that you must know in order to successfully migrate to a HADR solution based on SQL Server AlwaysOn technology, which implements AlwaysOn Failover Cluster Instances for high availability and AlwaysOn Availability Groups for disaster recovery.

2012-04-13

2,738 reads

Blogs

SQL Server Time Bombs

By

Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...

Book Review: A Radical Enterprise

By

I grabbed this book over the 2024 holiday season as it was on sale...

Advice I Like: Investing and Growing Rich

By

Investing small amounts of money over a long time works miracles, but no one...

Read the latest Blogs

Forums

Dateadd with a numeric value

By MMartin1

Comments posted to this topic are about the item Dateadd with a numeric value

A Poor Data Model

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Poor Data Model

Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions

By Abhinay Malipeddi

Comments posted to this topic are about the item Determining Whether Home Addresses Fall...

Visit the forum

Question of the Day

Dateadd with a numeric value

What is returned from the following query ?

declare @currentDateTime DATETIME = '2025-01-01 00:00:00.000'

select  dateadd(hour, 3.0/2, @currentDateTime);

See possible answers