SQL timed automatic backup (timed job)

The first step:

Right-click to start SQL Server agent

Step Two:

Right-click Job, New Job

Step Three:

Fill in the Job name

Fourth Step:

Create a new step, fill in the Step name, select the database that needs to be backed up regularly (take mydb for example)

Fifth Step:

Fill in Backup command: Backup DATABASE MyDB to disk= ' D://backup. BAK ', here's d://backup. Bak is the backup path and file name

Sixth step:

Create a new plan.

Seventh Step:

Talk not much, look at the picture ...

OK, get it done!

Don't forget to share it with more people.

SQL timed automatic backup (timed job)