Step By Step Guide to Schedule the SQL-Server Full Database Backup

Step By Step Guide to Schedule the SQL-Server Full Database Backup

access_timeFriday, 20 April, 2018 chat_bubble_outline0 comments

The future is data and the Database is the heart of any application, no one is afforded to any type of data loss. That's why the DB backup is very important part of any live application as well as every DBA or Database Developer Jobs.

Typically the Database backup's are 3 types.

1) Full Database Backup

2) Differential Database Backup

3) Transactional Database Backup

In this article, I will provide the step by step guide to schedule the SQL Server full Database Backup through the maintenance plan wizard.

Step - 1:-

Maintenane Plan Wizard

Step - 2:-

New Job Schedule

Step - 3:-

Select Maintenance Tasks

Step - 4:-

Maintenance Task Order

Step - 5:-

Configure the maintenance task

Step - 6:-

Define Backup Database Task

Step - 7:-

Select the backup database

Step - 8:-

Define Reorganize Index Task

Step - 9:-

Configure Reorganize Index Task

Step - 10:-

Define Update Statistics Task

Step - 11:-

Define Database Check Integrity Task

Step - 12:-

Select Report Option

Step - 13:-

Complete the wizard

Click on the "Finish" button and the full database backup has been scheduled successfully.

folder_openAssigned tags

0 Comments

Leave a Comment: