DR replication type for Failover and recover

• Mamus

  SSC Rookie

  Points: 28

  More actions

  June 26, 2015 at 2:51 am

  #298177

  Hello,

  I will like to know what type of replication is best and easiest to startup on the DR site in event of a failover for an SQL server with very high transaction occurring on the database.

  I normally handle Oracle database and we use SAN to SAN replication to the DR site, all w have to do is mount the replicated disks at the DR site and Startup the database.

  How do i achieve this on SQL database including having the using logging details work at the DR site.

  Thank you.

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  June 26, 2015 at 7:47 am

  #1808403

  What SQL Server version you are using? Check the feature "Always On" of SQL Server 2012 if using SQL 2012.

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."

• Mamus

  SSC Rookie

  Points: 28

  More actions

  June 26, 2015 at 8:35 am

  #1808420

  Hello,

  version is

  Microsoft SQL Server 2012 - 11.0.5058.0 (X64)

  May 14 2014 18:34:29

  Copyright (c) Microsoft Corporation

  Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: )

  Thanks