SQL Server settings automatically back up the database

1. SQL Server simply sets up scheduled tasks for the backup database operation.

First you need to open some settings

The following commands are executed:

' Show advanced Options ' 1 ;   GO   RECONFIGURE;   GO   'Agent XPs'1;   Go   RECONFIGURE   go

If you do not do this, you will get an error:

2. It is best to change the service of SQL Server Agent to Automatic mode. Enable the database to be processed automatically

Otherwise, the execution will error.

3. Recommended Scheduled Tasks

New Maintenance Plan Wizard

Define Schedule Frequency

Select the appropriate plan type

Select a specific database

Select Directory selection using compression

Add Schedule Success

And then test it out.

For execution

Verify the effect.

SQL Server settings automatically back up the database