Carbonite Support > Support for Microsoft SQL Serv...

Support for Microsoft SQL Server 2012 AlwaysON Availability Group

Summary:

Carbonite Safe Server Backup (CSSB) provides limited backup support for Microsoft SQL Server 2012 AlwaysON Availability Group. Only databases in the Primary replica can be backed up. Databases in the Secondary replica cannot be backed up.

After a successful restore of databases in the Primary replica, the Database Availability Group (DAG) configuration must be destroyed and reconfigured.

This article applies to:

Carbonite Plans Products Platforms
Power and Ultimate (Not sure?) Carbonite Safe Server Backup (Not sure?) Windows

Solution:

Restoring Data to the Primary Replica

    1. Remove the database from the availability group.
    2. Using Carbonite Safe Server Backup (CSSB), run a SQL database restore to the original location.

Reconfiguring the DAG Configuration

The SQL engine cannot roll back changes in the Secondary replica databases to match the restored databases in the Primary replica after a restore event.

Therefore, the DAG must be recreated from scratch after restoring databases on the server hosting the Primary replica.

  1. Delete the orphan database(s) from the servers hosting the Secondary replica.
  2. Re-establish the Database Availability Group (DAG) by recreating it from scratch.
    1. On the server hosting Primary replica , create a new DAG.
    2. Select FULL synchronization. This will start a data sync by performing Full and Log backups for each of the selected databases.
    3. The database is restored to each Secondary and attached to the availability group.
  3. After the database has been added to the availability group, perform a Full backup in CSSB to create a new baseline backup.
Feedback