Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to set up an automatic backup database in MSSQL. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

First, open MSSQL2008, and then in the "Administration" category, double-click the "maintenance plans" subcategory, at this point, if you have previously set a task schedule, the task list will be displayed; if not, nothing will be displayed.

Right-click on maintenance Plan, select New maintenance Plan, and then enter a name, here we enter the default name "MaintenancePlan", and then confirm. Then in the toolbar, in the General tab, drag backup Database tasks to the design form, as shown:

Then, double-click on the backup Database Task in the design interface, and then set the various properties in the pop-up dialog box:

When the settings are complete, click OK. Then in the scheduled task, click the calendar icon at the right end to set the automatic trigger time:

Then a pop-up box appears, and in the pop-up box, we make the following settings:

So, if we set it to trigger at 22:38 every night, then click OK, and finally click "ctrl+s" to save, we will find that in the maintenance plan and in the job of the sqlServer agent, two names are generated:

Mission plans for MaintenancePlan and MaintenancePlan.Subplan_1. Added successfully!

After reading the above, do you have any further understanding of how to set up an automatic backup database in MSSQL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.