SQL Server Performance

Corrupt Full Backup ?

Discussion in 'SQL Server 2008 General DBA Questions' started by acki4711, Aug 19, 2010.

  1. acki4711 Member

    Hi all,
    If I have the following backup scenario:
    FullBackup1
    TransLogBackup1
    TransLogBackup2
    FullBackup2
    TransLogBackup3
    TransLogBackup4
    Assuming the FullBackup2 is corrupt, can I restore FullBackup1, TranslogBackup1, TransLogBackup2, TransLogBackup3, TransLogBackup4 ???
    Technicaly it's possible, the question is do I have all transactions or are some transactions missed from FullBackup2.
    Any help is highly appreciated.
    acki4711
    acki4711, Aug 19, 2010
    #2

  2. ashish287 New Member

    yes its possible.
    you can recover completely from last working backup and till last working log backup.
    ashish287, Aug 19, 2010
    #3

  3. satya Moderator

    satya, Aug 20, 2010
    #4

  4. ashish287 New Member

    satya,
    i think he is talking about restore not backup option
    ashish287, Aug 20, 2010
    #5

  5. satya Moderator

    True, but I wanted to refer about new option introduced in SQL 2005 to avoid any mistmatch of LSN with full backups.
    satya, Aug 24, 2010
    #6

Share This Page