Configure Backup on Secondary Replica

Configure Backup on Secondary Replica.

AlwaysOn Hish Availability Groups provides Backup on Secondary database to overcome load on Primary Database.

As Secondary database is Read-Only replica so you can’t execute any code directly, you need to create Maintenance Plan for backup.

AlwaysOn High Availability Groups only Provides “Copy-Only Backup” at Secondary replica, it means differential backup is not available at secondary replica.

Configure backup on Server2.

Step1 : Expand “Management” and click on “New Maintenance Plan..”

1

 

Step2 : Apply proper name to maintenance plan and configure regular schedule.

Click on change will create a job same maintenance plan name and you can define a schedule to execute job and run it manually as per your need.

2

 

Step3 : On the select “Back Up Database  (Full)” on Select Maintenance Tasks windows and click on “Next”.

4

 

Step4 : Select “AGDatabase” on “Define Backup Database (Full) Task”.

6

 

Click on Check Box  ”Copy-Only Backup” and provide backup folder path.

7

–> Select “Report Options” and click on Next.

–> Click on “Finish” to complete the wizard and close it.

 

Thanks & Regards,

Nirav Gajjar