Re: How to "undo" a delete with cascades
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 30 Aug 2005 21:37:03 +0000 (UTC)
(dsfsdfs878@xxxxxxxxxxxxx) writes:
> Somebody accidently deleted a record with cascade deletes
> and took out about 80 records.
>
> The database has been used heavily since then.
>
> How do I put back the data?
>
> I have spent hours researching BOL and all I can find
> is how to restore the database to a point in time.
>
> But that will lose all the work done after the mistake.
>
> (We do a full backup every week and log backup every day)
>
> Is there a standard way to do this?
Yes, if you have bought one of those log-viewer tools, that offers
this function (by reading the transaction log, and from that generates
a script.) Check out http://www.lumigent.com and http://www.logpi.com
for two offerings.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
- References:
- How to "undo" a delete with cascades
- From: dsfsdfs878
- How to "undo" a delete with cascades
- Prev by Date: Re: Strange date/time anomaly, or am I just stoopid?
- Next by Date: Re: Can I access my private db through my web server?
- Previous by thread: Re: How to "undo" a delete with cascades
- Next by thread: Strange date/time anomaly, or am I just stoopid?
- Index(es):
Relevant Pages
|
