SQL AlwaysOn Scheduled Task backup settings

SQL Alwayson Scheduled Task backup settings

High Availability Group Backup parameter settings

1. Log in to the admin console of the SQL primary replica and expand the High Availability option.

650) this.width=650; "title=" clip_image001 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image001 "src=" http://s3.51cto.com/wyfs02/M02/8F/8B/ Wkiom1jkhffhinqaaabddhgzvda542.png "" 353 "height=" 468 "/>

2. Right-click on the AlwaysOn High Availability Group (here: AW1) and select Properties.

650) this.width=650; "title=" clip_image002 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image002 "src=" http://s3.51cto.com/wyfs02/M00/8F/8B/ Wkiom1jkhfiqerz4aaa-yzczqrm251.png "" "height=" 273 "/>

3. Click Backup Preferences, right tick backup from primary copy

650) this.width=650; "title=" clip_image004 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image004 "src=" http://s3.51cto.com/wyfs02/M01/8F/8B/ Wkiom1jkhfmstbncaaeczqq7d0w518.jpg "" 654 "height=" 556 "/>

To create a backup scheduled task for a database

1. Expand Management options, select Maintenance Plan

650) this.width=650; "title=" clip_image005 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image005 "src=" http://s3.51cto.com/wyfs02/M00/8F/89/wKioL1jkhFqQbcM_ Aabczuuipx8779.png "" 349 "height=" 484 "/>

2. Right-click the Select Maintenance Plan Wizard:

650) this.width=650; "title=" clip_image007 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image007 "src=" http://s3.51cto.com/wyfs02/M01/8F/8B/ Wkiom1jkhfvdqptpaablsa1fbmc263.jpg "" Height= "/>"

Click Next

650) this.width=650; "title=" clip_image009 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image009 "src=" http://s3.51cto.com/wyfs02/M02/8F/8B/ Wkiom1jkhfvavkh4aab6wpqatqs679.jpg "" 434 "height=" 354 "/>

3. After entering the plan name, click on the Change button in the lower right corner, here is the time to configure the scheduled execution, we can choose the period of execution, time and other related content:

650) this.width=650; "title=" clip_image011 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image011 "src=" http://s3.51cto.com/wyfs02/M00/8F/8B/wKiom1jkhFyChW3ZAAB_ E-iz_pg780.jpg "" 437 "height=" 357 "/>

650) this.width=650; "title=" clip_image013 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image013 "src=" http://s3.51cto.com/wyfs02/M01/8F/8B/ Wkiom1jkhf2db3oeaab9ra0vlk8022.jpg "" 435 "height=" "the"/>

4. When the scheduled task time is set, click OK and proceed to the next step, in which we can select the scheduled task, for example: Back up the full database, the differential database, log, etc., tick the task to do, click Next.

650) this.width=650; "title=" clip_image015 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image015 "src=" http://s3.51cto.com/wyfs02/M01/8F/89/ Wkiol1jkhf6ic8gjaab8qvjz-rs586.jpg "" 436 "height=" 352 "/>

650) this.width=650; "title=" clip_image017 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image017 "src=" http://s3.51cto.com/wyfs02/M00/8F/8B/wKiom1jkhF_ B2wueaab0d2ee0oe833.jpg "" 434 "height=" 352 "/>

5. This step requires selecting the database to execute the plan and the path to the database backup:

650) this.width=650; "title=" clip_image019 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image019 "src=" http://s3.51cto.com/wyfs02/M00/8F/89/ Wkiol1jkhgdtp9k9aab3bjqaesy658.jpg "" 435 "height=" 399 "/>

6. Set the backup path and backup file extension in the Destination tab, such as:

650) this.width=650; "title=" clip_image021 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image021 "src=" http://s3.51cto.com/wyfs02/M02/8F/89/ Wkiol1jkhggqqhi5aaczijsjvi8697.jpg "" 439 "height=" 405 "/>

7. Set the backup expiration time in the option, etc., according to the actual situation, such as:

650) this.width=650; "title=" clip_image023 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image023 "src=" http://s3.51cto.com/wyfs02/M01/8F/89/ Wkiol1jkhgkq4vlzaacgjnu0v-w560.jpg "" 439 "height=" 410 "/>

8. Periodically delete the backup files that have been saved for a long time (depending on the actual situation), such as:

650) this.width=650; "title=" clip_image025 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image025 "src=" http://s3.51cto.com/wyfs02/M02/8F/8B/ Wkiom1jkhgobah7gaaccwjgjw94608.jpg "" 442 "height=" 444 "/>

650) this.width=650; "title=" clip_image027 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image027 "src=" http://s3.51cto.com/wyfs02/M01/8F/8B/ Wkiom1jkhgohvojiaabzfeiulva354.jpg "" 445 "height=" 363 "/>

9. Click Next, click Finish, such as:

650) this.width=650; "title=" clip_image029 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image029 "src=" http://s3.51cto.com/wyfs02/M00/8F/8B/ Wkiom1jkhgsyvs1haablovhihfc339.jpg "" 447 "height=" 363 "/>

650) this.width=650; "title=" clip_image031 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" clip_image031 "src=" http://s3.51cto.com/wyfs02/M02/8F/8B/ Wkiom1jkhgxdjvraaab--eqmp_4615.jpg "" 449 "height=" 365 "/>

10. Set up differential and log backups as per the above methods.

SQL AlwaysOn Scheduled Task backup settings