SQL Server R2 scheduled backup task settings

One, SQL Server scheduled backup needs to turn on the SQL Server Agent service.

Right-click SQL Server Agent Select startup

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/98/EE/wKioL1lCCBCy2yH0AAA0Ju1bmPo317.png "style=" float : none; "title=" Qq20170615120111.png "alt=" Wkiol1lccbcy2yh0aaa0ju1bmpo317.png "/>

Pop-Up Confirmation Launch dialog, point is

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/98/EE/wKioL1lCCBCTDezxAAAU__DVFJk900.png "style=" float : none; "title=" 7.png "alt=" Wkiol1lccbctdezxaaau__dvfjk900.png "/>

Wait for startup to succeed

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/98/EE/wKiom1lCCBHA2fUGAAAJ2jGRa4M539.png "style=" float : none; "title=" 8.png "alt=" Wkiom1lccbha2fugaaaj2jgra4m539.png "/>

For example, the SQL Agent started successfully

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/98/EE/wKiom1lCCBGjlBWwAAAO6lQiSKE187.png "style=" float : none; "title=" 9.png "alt=" Wkiom1lccbgjlbwwaaao6lqiske187.png "/>

Second, configure the Scheduled tasks

Ensure that the agent server starts, right-click Maintenance plan, select Maintenance Plan Wizard

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/98/F5/wKioL1lCNoHjdmlkAABQGqaYio0790.png-wh_500x0-wm_ 3-wmp_4-s_667102753.png "style=" Float:none; "title=" 1.png "alt=" Wkiol1lcnohjdmlkaabqgqayio0790.png-wh_50 "/>

The Welcome screen appears and select Next

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/98/F5/wKiom1lCNoLDaB4nAADUqFofzns624.png-wh_500x0-wm_ 3-wmp_4-s_936192553.png "style=" Float:none; "title=" 2.png "alt=" Wkiom1lcnoldab4naaduqfofzns624.png-wh_50 "/>

Click Change in the interface, set the non-frequency

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/98/F5/wKioL1lCNoKScD72AAA4wyrozEQ578.png-wh_500x0-wm_ 3-wmp_4-s_1884155508.png "style=" Float:none; "title=" 3.png "alt=" Wkiol1lcnokscd72aaa4wyrozeq578.png-wh_50 "/>

I am setting up a daily backup, the execution time is 00:00:00

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/98/F5/wKiom1lCNoPBn33VAABF4I5sNws359.png-wh_500x0-wm_ 3-wmp_4-s_1379262428.png "style=" Float:none; "title=" 4.png "alt=" Wkiom1lcnopbn33vaabf4i5snws359.png-wh_50 "/>

After Setup is complete, the backup odds will appear briefly

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/98/F5/wKiom1lCNoPBB49JAAA-ww6cIPE553.png-wh_500x0-wm_ 3-wmp_4-s_1852018621.png "style=" Float:none; "title=" 5.png "alt=" Wkiom1lcnopbb49jaaa-ww6cipe553.png-wh_50 "/>

Choose how you want to back up your data, I choose a full backup (trained according to my production environment)

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/98/F5/wKioL1lCNoOCdIaZAABI3qhyXys074.png-wh_500x0-wm_ 3-wmp_4-s_3783198331.png "style=" Float:none; "title=" 6.png "alt=" Wkiol1lcnoocdiazaabi3qhyxys074.png-wh_50 "/>

If you choose a variety of backup methods, then there will be more, all will choose the order of backup, because I only choose one of the backup method, so does not involve the order of backup

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M01/98/F5/wKioL1lCNoTQpJ4dAABCBtjMakM433.png-wh_500x0-wm_ 3-wmp_4-s_3992053189.png "style=" Float:none; "title=" 7.png "alt=" Wkiol1lcnotqpj4daabcbtjmakm433.png-wh_50 "/>

After selecting the complete order, click Next to go to the following interface, set up to back up that database, you can select multiple. According to the definition of individual production environment

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/98/F5/wKiom1lCNoSTL_UCAAB7inZqudM988.png-wh_500x0-wm_ 3-wmp_4-s_1828261096.png "style=" Float:none; "title=" 8.png "alt=" Wkiom1lcnostl_ucaab7inzqudm988.png-wh_50 "/>

After selecting the backed up database, set the file location after backup (depending on your production environment); If it is a backup of multiple databases, it is recommended to create a sub-directory for each database to pick up the check, so that the backup of the data has a sense of hierarchy; Xu Verify backup integrity, click Next

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/98/F5/wKiom1lCNoTgYHMOAAB1Bd9N2zU745.png-wh_500x0-wm_ 3-wmp_4-s_2063424399.png "style=" Float:none; "title=" 9.png "alt=" Wkiom1lcnotgyhmoaab1bd9n2zu745.png-wh_50 "/>

After clicking Next, set the location of the backup report, back up the database in SQL Server to produce a report, that is the interface

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/98/F5/wKioL1lCNoXjvJLGAAA5-7VLevA356.png-wh_500x0-wm_ 3-wmp_4-s_2959643844.png "style=" Float:none; "title=" 10.png "alt=" Wkiol1lcnoxjvjlgaaa5-7vleva356.png-wh_50 "/>

After selecting the report storage location, go to the completion screen below and click Finish to generate the backup script. Click: Finish

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/98/F5/wKioL1lCNoXDNKSgAAA4Ms-CdHo067.png-wh_500x0-wm_ 3-wmp_4-s_3206817312.png "style=" Float:none; "title=" 12.png "alt=" Wkiol1lcnoxdnksgaaa4ms-cdho067.png-wh_50 "/>

See the following interface to prove that the backup script is configured.

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M00/98/F5/wKiom1lCNoWRta5HAABO6r3girg411.png-wh_500x0-wm_ 3-wmp_4-s_3710453994.png "style=" Float:none; "title=" 13.png "alt=" Wkiom1lcnowrta5haabo6r3girg411.png-wh_50 "/>

Verify that there are scheduled tasks in the agent job below

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M00/98/F5/wKioL1lCNoby0YpiAAA84IEyzuU822.png-wh_500x0-wm_ 3-wmp_4-s_4174763586.png "style=" Float:none; "title=" 14.png "alt=" Wkiol1lcnoby0ypiaaa84ieyzuu822.png-wh_50 "/>

Here's how to wait until tomorrow to see if the backup was successful.

If you want to perform the task immediately, as shown below;

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/98/F6/wKioL1lCPhexsliCAABRa0ofdNg501.png "title=" 15. PNG "alt=" Wkiol1lcphexslicaabra0ofdng501.png "/>

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/98/F6/wKioL1lCPljDaCSOAAAjz4PfmKE802.png "title=" 16. PNG "alt=" Wkiol1lcpljdacsoaaajz4pfmke802.png "/>

Look at the output after the execution.

Output one: Backing up files

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/98/F7/wKioL1lCPtPzM0VYAAANzqTB53s010.png "style=" float : none; "title=" 17.png "alt=" Wkiol1lcptpzm0vyaaanzqtb53s010.png "/>

Output II: Backup report

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/98/F7/wKiom1lCPtSDXexhAACDuCli8rM390.png "style=" float : none; "title=" 18.png "alt=" Wkiom1lcptsdxexhaacducli8rm390.png "/>

This article is from the "Learning to change the Destiny" blog, please make sure to keep this source http://xinsir.blog.51cto.com/5038915/1937194

SQL Server R2 scheduled backup task settings