Re: Rolling Back a commited transaction
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 11/27/03
- Previous message: Daniel Jorge: "Rolling Back a commited transaction"
- In reply to: Daniel Jorge: "Rolling Back a commited transaction"
- Next in thread: Daniel Jorge: "Re: Rolling Back a commited transaction"
- Reply: Daniel Jorge: "Re: Rolling Back a commited transaction"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 27 Nov 2003 11:29:12 -0500
If you are backing up your transaction log and if you noted the time of the
delete, you can restore the database backup to a new database and restore
all of the logs with the STOPAT option. That option lets you specify a date
and time after which it does not recover the log. At that point, you can
copy over the data.
Alternatively, Lumigent has excellent tools - www.lumigent.com.
--
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Daniel Jorge" <danielj@afc.com.br> wrote in message
news:uTGfVLQtDHA.1224@TK2MSFTNGP09.phx.gbl...
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
- Previous message: Daniel Jorge: "Rolling Back a commited transaction"
- In reply to: Daniel Jorge: "Rolling Back a commited transaction"
- Next in thread: Daniel Jorge: "Re: Rolling Back a commited transaction"
- Reply: Daniel Jorge: "Re: Rolling Back a commited transaction"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
