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

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

access_timeSunday, 22 April, 2018 chat_bubble_outline0 comments

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

When We Schedule Differential Database Backup

We will schedule differential database backup when the database size is too large then our backup strategy should be to take the full backup on a span of time periods like 1 week or 2 weeks as per your requirement and between those two full backups, we will schedule the differential backup every day. 

How To Schedule Differential Database Backup

Step - 1:-

Maintenance 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:-

Select The Database

Step - 7:-

Define Database Check Integrity Task

Step - 8:-

Step - 9:-

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

folder_openAssigned tags

0 Comments

Leave a Comment: