Post reply

regenerate deleted records

  • February 9, 2013 at 4:52 am

    #288965

    Is there any rollback funtionality in sql server 2004 r2 ? i can recover deleted records

  • February 9, 2013 at 5:37 am

    #1586216

    I assume you mean 2008 R2, as there was no SQL Server 2004.

    If the delete was done within a transaction and the transaction has not been committed, then Rollback will undo the delete. If the delete has been committed then it's part of the permanent database and will require that you restore a backup to get the deleted data back.

    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

  • February 9, 2013 at 6:02 am

    #1586218

    Thank you

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

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