Home > IT Answers > Storage > bacup and recovery
Jos
5 pts.
 bacup and recovery
Backup & recovery, t-log
if you have a full backup and three subsequent t-log backups, why you cannot restore the third t-log backup after restoring the second t-log backup with recovery?

Software/Hardware used:
ASKED: December 22, 2007  11:13 PM
UPDATED: February 22, 2008  5:46 AM
RELATED QUESTIONS
Answer Wiki:
What backup software are u using? Does T-log stand for transaction logs? So we are talking Exchange?
Last Wiki Answer Submitted:  December 23, 2007  7:55 am  by  B00M3R   1,190 pts.
All Answer Wiki Contributors:  B00M3R   1,190 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

mainly we are using offline Backup

Balaram04
 15 pts.
 

What software are you backing up? Exchange, SQL, Oracle, etc?

Denny Cherry
 64,520 pts.
 

When you a restore of T-logs (if that is transaction logs) with recovery, the database application assumes that the database recovery is complee and will try to get “online”.
with recovery option should be used when you are restoring the last set of transaction logs …

Nbu
 10 pts.
 

After the second transaction log is restored with recovery and the database is brought online, the restore chain of LSNs is broken. You can’t restore the next log because records could have been changed between when the second file is restored and the third restore is started.

Denny Cherry
 64,520 pts.