Post reply

how 2 rollback in sqlserver2000

  • January 16, 2005 at 12:40 am

    #61519

    i got a pblm. i unknowingly deleted a row using "delete" command. but i need to get back it. how should i do it?

    thanx for all ur  help

    regards

    Rajiv.

  • January 16, 2005 at 6:44 am

    #537591

    As far as I know, there is no native support in SQL Server for rolling back specific transactions, though I believe there are third-party tools that can do this.

    But a simple way is to restore a recent copy of the database to a new separate db (ie don't overwrite what's there!) and then perform an INSERT from the restored db to the live db, just for the missing row.

    Phil

  • January 17, 2005 at 5:16 pm

    #537751

    if the dba did not take complete backup of  the database, he can take a tran log backup, and do point in time recovery, on a different database, hence get you back your data..

     

    if he already did a complete backup, then either you need to go back to previous backup that was already taken before you did your magic..

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

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