Maintenance Plans – Full Backup SQL database

Hi Guys, In this article, I am going to show you one of the important things that the system administrator responsible for. There are DBA guys who know how to deal with SQL database, tables, rows, etc…

The DBA does not know how to backup databases or create any maintenance plan for the SQL server, therefore in this article, you will learn how to create a Full Backup using the Maintenance Plan in Server. This is my All DB’S I have on my LAB environment:

Maintenance Plans - Full Backup SQL database

I would like to backup all databases, on the bottom of the page you need to click on “Maintenance Plain” And then Maintenance Plan Wizard”:

BackupSQL

Here you should insert some details:

Maintenance Plans - Full Backup SQL database

Select “Backup Database” (FULL):

Maintenance Plans - Full Backup SQL database

Next:

Maintenance Plans - Full Backup SQL database

Important:

Make sure the backup will not be on the SQL server.

Make sure that you have the write+read permission on the destination location you have set:

Maintenance Plans - Full Backup SQL database

And now we need the set the schedule:

sql_scheduler

Set days,times, which suitable you:

Maintenance Plans - Full Backup SQL database

You can insert your Email address and once the backup will finish you will receive a notification:

Maintenance Plans - Full Backup SQL database

Finish:

Finished

Close:

Close

New Task has created:

Maintenance Plans - Full Backup SQL database

Here is the backup:

Maintenance Plans - Full Backup SQL database