Post reply

Recover transactions without backup

  • June 11, 2008 at 1:24 pm

    #192078

    Can someone tell me if I can recover transactions in the log that have not been backed up?

    A co-worker performed a drop table and we have no backup.

    I know... I know...

    I installed ApexSQL Log and it told me there were some transactions there, but I can't see why this can't be done without a third party.

    Thanks!

  • June 11, 2008 at 1:47 pm

    #827498

    Questions.

    Is the database using the Full Recovery Model?

    Do you have a current full backup from prior to this event?

    If so, you can take a transaction log backup now, restore the the full backup to a new database name (ProdRecover for example) with the NORECOVERY option, restore to the point in time using all T-Log backups since the last Full Backup specifying the a time JUST BEFORE the table was dropped. You can then recover the table for that database and replace it in the Production database.

    😎

  • June 11, 2008 at 2:37 pm

    #827525

    Yes, the database is running in Full Recovery Model.

    One problem... We have no backup.

    Is it safe to say the data is lost?

  • June 11, 2008 at 2:43 pm

    #827530

    You are going to need a third party product to recover the data from the transaction log.

    Then, you will need to setup a backup plan for regularly scheduled full, possibly differential (if the database is too large for night full backups), and transaction log backups.

    😎

  • June 11, 2008 at 2:52 pm

    #827541

    Thanks Lynn

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

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