Configure Backup on Secondary Replica

Posted on by

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