Post reply

Transaction Logfile corruption

  • April 1, 2007 at 1:11 pm

    #194993

    Transaction logfile of a database is corrupt. How to recover tha transaction logfile?

  • April 3, 2007 at 1:39 am

    #698229

    Restore the latest database backup you have and any transaction log backups since then.

    You do have a backup?

    What errors are you getting and where?

    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

  • April 3, 2007 at 10:44 am

    #698351

    if you are sure you're tran log only is corrupt and you have no backups, you can try detaching the database then reattach with sp_attach_single_file_db, specifying .mdf only (see BOL)

    restore from backup is best option though if you have a backup

     

     

    ---------------------------------------------------------------------

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply