bacup and recovery

5 pts.
Tags:
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?
ASKED: December 22, 2007  11:13 PM
UPDATED: February 22, 2008  5:46 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

What backup software are u using?
Does T-log stand for transaction logs?
So we are talking Exchange?

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Balaram04
    mainly we are using offline Backup
    15 pointsBadges:
    report
  • Denny Cherry
    What software are you backing up? Exchange, SQL, Oracle, etc?
    65,450 pointsBadges:
    report
  • Nbu
    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 ...
    10 pointsBadges:
    report
  • Denny Cherry
    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.
    65,450 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following