Post reply

Lost Transaction Log File

  • November 6, 2008 at 9:02 pm

    #126795

    Hi,

    How to reterive the lost transaction log file?

    Koteswar Rao.Y

  • November 6, 2008 at 9:11 pm

    #895305

    Can you give some more information? I think you can run the DBCC checkDB statement with REPORT_ALLOW_DATA_LOSS option. It can retrive the log file, however, there may be some data loss

    Thanks & Regards,
    Sudeepta.
    http://twitter.com/skganguly

  • November 7, 2008 at 4:47 am

    #895413

    AS my friend recommanded there will be DATA LOSS, so think before to use this 🙂

  • November 7, 2008 at 4:59 am

    #895420

    use DBCC CHECKDB, DBCC DBREPAIR (sql 2000) and then observe the display output.

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

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