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

In this issue, the editor will bring you about how to build a new maintenance plan in the SQL Server database. The article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article.

1. Open the SQL Server 2008 management interface, expand SQL Server Group-Administration-maintenance Plan, and right-click * * maintenance Plan * *

two。 Click the maintenance Plan Wizard, the dialog box of the maintenance Plan Wizard appears, click the next button, and the dialog box for selecting plan properties appears.

3. Enter the name of the implementation maintenance plan, select "overall arrangement of the whole plan or no plan", click the "change" button to modify the properties of the job plan, and according to the actual situation, select the type of plan, the frequency of execution, the start and end date of the task, and then click the "OK" button.

4. Click the "next" button, the dialog box for selecting maintenance tasks appears, and the "backup database (complete)" maintenance task is selected. if you need to select other maintenance tasks, you can check it according to the actual situation, and after confirming it, click the "next" button, and the dialog box for maintaining the order of tasks appears.

5. Users can modify the execution order of maintenance tasks according to the actual situation, click "next", and the definition "backup database (complete)" task dialog box appears. Select the database that needs to be backed up.

6. Select the target address of the backup database, click the [Browse] icon, the dialog box to locate the folder appears, select the target address of the backup database, click the [OK] button, check "verify backup integrity", and click [next]. Click [next], the dialog box for selecting report options appears, according to the default settings, click the "next" button, and the dialog box to complete the wizard appears. Click the "finish" button and the progress dialog box of the maintenance Plan Wizard appears.

7. Click the "close" button to view the newly created maintenance plan in the maintenance plan, so that the database backup maintenance plan has been established.

This is how to create a new maintenance plan in the SQL Server database shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.