Rolling Back a commited transaction

From: Daniel Jorge (danielj_at_afc.com.br)
Date: 11/27/03 

Date: Thu, 27 Nov 2003 14:23:45 -0200

Hi there,

    One of our user had (and still has) the right to post DELETE commands to
one of our main tables in the Database. I usually hate when managers has
this kind of rights. Generate a lot of trouble.
    The scene is as following: he deleted some records from a very important
table in production environment. He was very careful in deleting all the
dependent records before.
    Now we need those records back. To generate them again we would have a
lot of work, envolving a lot of resources. Is it possible to rollback a
database to a certain point of its life... kinda... I need it to the way it
was today by 7:00 pm. Or anything like this. I need to rollback this
database to the closest point it was at the exact moment the fu*.. (sorry)
deleted the records.

    Thanks in advance.

Daniel

Relevant Pages

  • Re: just wondering about MSKB 828481
    ... seems to depend on the database being in other than ... > rollback I'll be OK. ... SQL Server doesn't, AFAIK, offer any native method for unravelling ... Steve Foster [SBS MVP] ...
    (microsoft.public.windows.server.sbs)
  • Re: How to transactionally update a DB Schema?
    ... You can execute DDL as part of an explicit transaction so that you can ... rollback in the case of an error. ... database prior the upgrade and restore if an error is encountered. ...
    (microsoft.public.sqlserver.server)
  • Re: Recovery from Delete statement using the transaction logs
    ... If you did, just do ROLLBACK. ... Are you performing regular transaction log backups? ... Is database in full or bulk logged recovery ...
    (microsoft.public.sqlserver.server)
  • Re: ROLLBACK a transaction
    ... execute your select query, but it would ignore all non-committed records as ... > I'm reading records from one database to another database, ... We have to do a rollback of all the ... > Is there a solution for this whitout changing the select to "......with ...
    (microsoft.public.sqlserver.programming)
  • Re: Scope of transaction processing wrapper
    ... Just pass the Database variable, and it will all rollback. ... This article illustrates transactions: ... My question is on the scope of what transaction ...
    (comp.databases.ms-access)