Automatic backup of SQL Server databases

Start SQL Server Management Studio, expand the Administration folder from Object Explorer, right-click Maintenance Plan, and then select New Maintenance Plan.

Enter a descriptive name and click the "OK" button.

A new maintenance plan is created and the designer is displayed.

Open the Toolbox and select Database Backup Tasks.

Place it on the designer. Double-click the task that you placed to specify which database to back up.

The database backup task settings screen is displayed.

Select Databases and select the database you want to schedule backups for. If necessary, specify other parameters, such as the destination folder for the backup.

Once you have confirmed by pressing the OK button, specify when you want to perform the backup next time. Click the calendar icon for the schedule in the subplan.

Here you can schedule how often and how often backups are started, and when to start. Specify the timing you want to back up and confirm it with the OK button.

Once you have specified a schedule, you are done. Make sure that the database is automatically backed up at the specified time.

By the way, this maintenance creates a job for SQL Server Agent internally, and you can see that if you look at the job because you are simply running it, you can see that the backup task you created has been added.