Backup Transaction Logs on all Databases

  • Wesley Brown

    SSChampion

    Points: 12045

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

    http://www.sqlserverio.com
    http://www.cactuss.org
    http://www.salssa.org

  • abmore

    Hall of Fame

    Points: 3628

    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?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply