Home Forums SQL Server 2019 SQL Server 2019 - Administration Create a database from backup when the backup transaction log is damage. RE: Create a database from backup when the backup transaction log is damage.

  • August 30, 2017 at 11:25 am

    #1957517

    A database backup doesn't contain all the transaction log, just part of the active portion. You can't skip restoring that (it's what makes the database consistent), but if the backup succeeded with the source DB having a damaged log file, then the backup should restore ok.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass