How to "undo" a delete with cascades

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dsfsdfs878@tiscali.co.uk - 30 Aug 2005 11:26 GMT

Hello,

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?

Morgan

Reply to this Message

Razvan Socol - 30 Aug 2005 15:14 GMT

Hello, Morgan

Restore the backup on another server (or as another database on the
same server) and then copy the missing rows (using a query that
accesses the linked server).

Razvan

Reply to this Message

Erland Sommarskog - 30 Aug 2005 22:37 GMT

> Somebody accidently deleted a record with cascade deletes
> and took out about 80 records.
[quoted text clipped - 11 lines]
>
> 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.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Reply to this Message