Post reply

Recover database using LDF File

  • October 4, 2013 at 11:56 am

    #280585

    Hi All,

    I have Database in SQL Server 2005 and database is in Full recovery mode.

    accidentally i trucate some of the tables which should be truncate from other database.

    is there any way to recover data or full database using ldf file.

    Please help me.

    Thanks in Advance

  • October 4, 2013 at 12:41 pm

    #1656010

    Restore your last full backup as a new database (restore with norecovery), restore all log backups taken up to the point of the accident WITH STOPAT and specify a time just before the accident. If the accident was after the last log backup, then take another log backup off the database with the missing tables and restore that WITH STOPAT and specify a time just before the accident.

    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

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

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