DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ37

Plan and configure a high availability and disaster recovery (HA/DR) environment

You have an Always On availability group deployed on Azure virtual machines. The availability group includes a database named DB1 and two nodes named SQL1 and SQL2. SQL1 is the primary replica.

You need to start a full backup of DB1 on SQL2.

Which statement should you run?

Explanation

A full database backup performed on a secondary replica in an Always On availability group must use COPY_ONLY. Copy-only backups do not affect the log chain or clear the differential bitmap, making them supported for offloading a full backup to the secondary replica.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!