Schedule A Database Backup In SQL Server

Here are the steps, 

Open SQL Server Management Studio.

sql server

Click Connect - To connect your database server,

connect

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

Click Management

Click Management

Click Next and provide the name of your Maintenance Plan,

Maintenance

Under Schedule - Click Change,

Name will be the same.

Schedule type: Recurring,

Schedule

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.

new job

new job

Click Next.

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

wizard

Click Next.

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

wizard

And select the Single database manually.

database

Click OK.

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

wizard

Set compression type to “Compress backup”.

wizard

Click Next.

Select the report generation path for a backup.

wizard

Click Next and then Finish.

wizard

So it has been successfully configured.

wizard

Click Close

object