• How would you get an incorrect checksum in the log anyway?

    Checksums are on database pages in the data file.

    There are instances of log corruption, that's not one of them.

    Absolutely do not detach and delete the log. Unless you want to convert corrupt and online database into database that won't attach.

    Take a look at this article. http://www.sqlservercentral.com/articles/65804/ and see the list of Do Nots.

    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