Backup Transaction Logs on all Databases

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  September 29, 2007 at 3:31 pm

  #178300

  Comments posted to this topic are about the item Backup Transaction Logs on all Databases

• abmore

  Hall of Fame

  Points: 3628

  More actions

  July 15, 2008 at 10:42 pm

  #843502

  How could we recover the database if my transaction log gets corrupted / anything will happ.

  Suppose I have FullBackup say, Full1.bak

  after this i have taken the differential backup say, diff1.bak

  and have schedule transaction file backup for every 1 hour say, trn1.bak

  trn2.bak.... it took upto trn5.bak

  if my trn3.bak corrupts then in this case how can i restore the database?

  2nd condition if my diff1.bak corrupts then how could i restore the database?