I have question on this backup\recovery.Let's assume there is a disaster at 6:14 pm and our recovery model is full and we take Full back up's at 12:00 am and differential's at 6 hrs interval and transactional one's for every 5 mins. So, in this case
to recover the db, we apply our FB(12:00)+Differential(6:00pm) + Transacational log 1(6:05)+transactional log(6:10) . We need to backup the tail to get the point in time restoration. Could any one tell when shall we backup the tail log?
is it before doing the restoration??
View Complete Post