MSSQL Create maintenance plan automatically back up database

one, back up the database

1, click "Manage--" Maintenance plan "right click on" New Task schedule "

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/7F/90/wKioL1cjALXQhqBrAAHdpnW-xSA668.png "style=" float: none; "title=" 1.png "alt=" Wkiol1cjalxqhqbraahdpnw-xsa668.png "/>

2, according to their own needs to set the automatic execution time of the backup plan, here I set the morning 12 to execute the backup plan.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7F/90/wKioL1cjALeQOyGtAAJeKt7bhjE330.png "style=" float: none; "title=" 3.png "alt=" Wkiol1cjaleqoygtaajekt7bhje330.png "/>

3. Add the BACKUP Database schedule

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7F/90/wKioL1cjALihn7b0AAGZvNlUyqg030.png "style=" float: none; "title=" 4.png "alt=" Wkiol1cjalihn7b0aagzvnluyqg030.png "/>

4, set the options for the backup database plan

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7F/90/wKioL1cjALvxbuYTAAGlJkCmWSU455.png "style=" float: none; "title=" 6.png "alt=" Wkiol1cjalvxbuytaagljkcmwsu455.png "/>

5, after the backup schedule is complete, you can perform a full backup immediately.

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7F/93/wKiom1cjApSDyWdTAAEbPYYWOqg670.png "title=" Bbb.png "alt=" Wkiom1cjapsdywdtaaebpyywoqg670.png "/>

Second, restore the database

1, right click on the database you need to restore, click on "Task--" Restore-"database".

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/7F/93/wKiom1ci__GBPLdGAAG7TGFF2HA039.png "style=" float: none; "title=" 8.png "alt=" Wkiom1ci__gbpldgaag7tgff2ha039.png "/>

2, select Restore the most recent backup set in the source database, or locate the backup set that you want to restore in the system file path on the source device.

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/7F/93/wKiom1ci__bwuaSGAAG8EqMlQOM150.png "style=" float: none; "title=" 10.png "alt=" Wkiom1ci__bwuasgaag8eqmlqom150.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/7F/90/wKioL1cjAMWzNoCRAAEU7EfpdI8506.png "style=" float: none; "title=" 11.png "alt=" Wkiol1cjamwznocraaeu7efpdi8506.png "/>

Error handling may occur when restoring a database file:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/7F/93/wKiom1ci__mCHWWBAACA_E94owA713.png "style=" float: none; "title=" Error.png "alt=" Wkiom1ci__mchwwbaaca_e94owa713.png "/>

when restoring a database, click Options on the Select page, tick Overwrite existing database (with REPLACE) , you can successfully restore the database after you click OK

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7F/93/wKiom1ci__mAIvPZAAC18-tODnI641.png "title=" error Resolv.png "style=" Float:none; "alt=" Wkiom1ci__maivpzaac18-todni641.png "/>

Complete the Restore:

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/7F/91/wKioL1cjB5GCXPzKAABIx2sdhzA012.png "title=" ok.png "alt=" Wkiol1cjb5gcxpzkaabix2sdhza012.png "/>

MSSQL Create maintenance plan automatically back up database