• 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?