Post reply

How to regain the Data after deleting if rollback doesnt work

  • January 9, 2012 at 5:43 am

    #391263

    Hi,

    I have accidentally deleted the data from my SQL server 2008.I have tried using rollback but im not getting the data back.

    Is there any possible way to get back my data which is of very high priority,.,,

    Please guide at the earliest

  • January 9, 2012 at 5:56 am

    #1430400

    Rollback will only work if you started an explicit transaction before the delete, and that transaction has not yet committed.

    To get the data back, get your latest database backup, restore it as a new DB (not over the current database), restore log backups up to the point just before the delete, then copy the data over to the main database.

    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

  • January 9, 2012 at 5:58 am

    #1430401

    Do you have any backups (Full,Log) prior to delete? if yes then restore the backup in any other machine like on UAT or dev then transfer the data using import/export.

  • January 9, 2012 at 6:24 am

    #1430414

    thanks.but i dont have the backup....and the transaction is committed,....In this scenario is there a possibility of getting the data back????

  • January 9, 2012 at 6:24 am

    #1430415

    thanks.but i dont have the backup....and the transaction is committed,....In this scenario is there a possibility of getting the data back????

  • January 9, 2012 at 6:26 am

    #1430416

    SameerKKhan (1/9/2012)

    thanks.but i dont have the backup....and the transaction is committed,....In this scenario is there a possibility of getting the data back????

    Retype it in the system.

    Plan C would be to find other places where you might have a copy of the DB (dev, test server). Maybe VM backup of the machine (they often fail but somethings it saves the mdf and ldf files correctly).

    Backup of the backup folder (assuming there ever was).

  • January 9, 2012 at 6:29 am

    #1430417

    SameerKKhan (1/9/2012)

    thanks.but i dont have the backup....and the transaction is committed,....In this scenario is there a possibility of getting the data back????

    Pretty much, no.

    You could spend $1000+ on a log reader that might be able to recover your data (but it's not guaranteed). Otherwise, accept that it's gone and start taking backups!

    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

  • January 9, 2012 at 6:45 am

    #1430424

    thanks frnds for the suggestions...

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

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