Home Forums SQL Server 2008 SQL Server 2008 Administration How can you issue a full backup and not interrupt the LSN's RE: How can you issue a full backup and not interrupt the LSN's

  • March 7, 2013 at 11:45 pm

    #1594831

    Full Backup taken Monday night 6:00 PM.

    T-Log backups taken every 2 hours starting at 8:00 PM until 6:00 PM Tuesday.

    Full Backup taken at 6:00 PM Tuesday.

    Full backups taken every 2 hours starting at 8:00 PM.

    System experiences a hdd failure at 9:00 AM Wednesday morning, you lose your production system database mdf file. Log file is good as it is on a separate disk drive. Perform a tail log backup of the log file.

    After successfully completing the tail log backup you start a restore of the full backup taken Tuesday night at 6:00 PM. Restore fails, the backup file is corrupt, unreadable. Copy from tape is also corrupt.

    Question, can you still restore your database to the point of the hdd failure.

    Answer, yes. You start with the full backup taken Monday night and start restoring all the t-log backups taken since that full backup.

    Full backups do not break the LSN chain for transaction logs.