Home Forums SQL Server 2005 Backups Backup Log Incorrect Function Message (nonrecoverable I/O error). RE: Backup Log Incorrect Function Message (nonrecoverable I/O error).

  • January 7, 2013 at 2:55 pm

    #1574542

    Just a comment on your 'solution', you got lucky there, SQL cannot always recreate the log file if it's lost. It's very possible that deleting the log file will result in the DB being unusable and a restore from backup being needed.

    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