AlwaysOn Database Block Backup Overview

SQL Server 2012 and later provides a high availability feature of database-level replication, the replication databases are organized logically by using availability groups, which create Windows cluster resource within the failover cluster management console. The replica of an availability group can be an SQL instance and the availability group listener is optional, depending on the requirement to connect to the replica of an availability group. There are a number of considerations to review in regards to configuring DPX Block Data Protection with SQL 2012 AlwaysOn, see Protecting AlwaysOn Availability Groups: Concepts and Considerations.

From the SQL Server management console, an availability database displays on both the availability group and the local instance that hosts the replica. However, in the DPX resource browser, the availability databases display on the availability group under the SQL cluster virtual node. The database does not display on the primary replica node because the backup will not work after a failover is initiated on the database to the replica node.

Last updated