Home Forums SQL Server 2012 SQL 2012 - General Has anyone implemented SQL Server 2012 Always On for disaster recovery RE: Has anyone implemented SQL Server 2012 Always On for disaster recovery

  • We just rolled out AlwaysOn in our reporting environment last week to replicate 2 databases from our data warehouse to allow our data analysts query the report databases without effecting the ETL processes during the day on the primary.

    The only issue we found when rolling out one of the databases was that we had to turn off transaction log backups on the primary while the replica ws being made on the secondary. Its very early days but so far all is good - the setup was very straighforward and we are not having any issues with latency - we set it up as Asynchronous-commit mode as our primary is in Melbourne and Secondary in Darwin.

    As I said its early days but so far so good!