Schedule A Database Backup In SQL Server

Here are the steps, 

Open SQL Server Management Studio.



Click Connect - To connect your database server,



Click Management, Maintenance plans, then right click to create a new maintenance plan Wizard,





Click Next and provide the name of your Maintenance Plan,



Under Schedule - Click Change,

Name will be the same.

Schedule type: Recurring,



Change the Frequency to daily. Set the daily frequency.

I have set the daily frequency for “Occurs Every 2 mins in between timings”.

No changed needed for Start date (It will takes the current system date automatically).

Click OK.





Click Next.

In the next window check Back up database (Full).



Click Next.

On the database selection Select All database or Whatever database you are going to take a backup.



And select the Single database manually.



Click OK.

Now choose the directory path for creating a database Bak file.



Set compression type to “Compress backup”.



Click Next.

Select the report generation path for a backup.



Click Next and then Finish.



So it has been successfully configured.



Click Close