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
  2. ashish287 New Member

    yes its possible.
    you can recover completely from last working backup and till last working log backup.
  3. satya Moderator

  4. ashish287 New Member

    satya,
    i think he is talking about restore not backup option
  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.

Share This Page