Restore of Transaction Logs

• JeffE

  Mr or Mrs. 500

  Points: 527

  More actions

  April 12, 2002 at 8:27 am

  #157611

  I am currently using ArcServ (tape) to do my bakups of the database and transaction logs. What is the normal procedure/steps that is used to bakup the database and transaction logs for the following environment. Keep in mind that the complete bakup is less than 7 gig.

  Bakup database every 4 hours.

  Backup Transaction logs every 30 minutes.

  This will give me 8 transaction log backups between each complete backup.

  If my database was to crash 2 hours after the last complete backup, all I am wanting to be able to do is restore the last complete backup and the last good transaction log backup. I unserstand that the transaction log backups must be incremental to do this. Is this even remotely possible? And is it possible with ArcServ? If so, where can I find the answer?

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 728159

  More actions

  April 12, 2002 at 10:10 am

  #427132

  It is possible. I think you will find the consensus among most experienced DBAs is to backup to disk, then get these to tape.

  If you experienced this crash, you would:

  • Restore the last full (2 hrs before
  • Restore the first t-log after the full (1.5 hours before)
  • Restore the second t-log after the full (1.0 hours before)
  • Restore the third t-log after the full (.5 hours before)
  • Restore the fourth t-log after the full (right before the crash)

  Steve Jones

  steve@dkranch.net

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com