Tail Log Backup

What is tail log backup? Where can we use it?

Questions by sharath206   answers by sharath206

Showing Answers 1 - 1 of 1 Answers

Kiran Patil

  • Mar 26th, 2008
 

Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time recovery.

Consider a scenerio where in, we have full backup of 12:00 noon, one Transactional log backup at 1:00 PM . The log backup is scheduled to run for every 1 hr.

If disaster happens at 1:30 PM then we can try to take tail log backup at 1:30 (after disaster). If we can take tail log backup then

In recovery, first restore full backup of 12:00 noon, then 1:00 PM log backup recovery and then last tail backup of 1:30 (After Disaster).

Hope this is clear, please feel free to correct me or add few more points to this.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions