SQL Server database backup implementation

1. Go to SQL Server, choose Manage> maintenance plan, right-click maintenance plan, find new maintenance plan, and select.

 

2. You can see that "new maintenance plan" can be set by default or by name. Click "OK;

 

3. See the following figure: Select the "plan" tab on the right and select the button on the right.

 

4. On the "frequency" tab,

Select "daily"

,

Run once. The time is: this parameter can be modified to the appropriate time. Click "OK.

 

 

5. Drag the backup database task and check database integrity to the right.

 

6. As shown in the figure;

 

7. Double-click the backup database task,

On the "database" tab, select a database on the right and click "OK.

8. Click the button on the right of the folder to change the folder and check the backup integrity.

 

 

9. Double-click

 

10. The following figure is displayed:

 

11. Select the database you want to back up and click "OK.

 

12. Save the backup.

This is just the most basic SQL server database backup tutorial, especially these functions are self-contained in mssqlserver, but some new friends may not know.