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

Step By Step Guide to Schedule the SQL-Server Transactional 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 Transactional Database Backup through the maintenance plan wizard.

When We Schedule Transactional Database BackUp

Transactional database backup is very important because through the transactional Database backup we will minimize the data loss probability because of the ideal condition transactional database backup schedule on every 10-15 min. That’s why transactional log backup must important in any disaster recovery condition to recover the data.

How To Schedule Transactional Database Backup

Step - 1:-

T-Log Maintenance Plan Wizard

Step - 2:-

New Job Schedule\

Step - 3:-

Select Maintenance Tasks

Step - 4:-

Select Maintenance Task Order

Step - 5:-

Configure Maintenance Task

Step - 6:-

Select backup database

Step - 7:-

Define Database Check Integrity Task

Step - 8:-

Select Report Options

Step - 9:-

Complete the Wizard

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

folder_openAssigned tags

0 Comments

Leave a Comment: