|
Home > Archive > Microsoft SQL Server forum > August 2005 > How to "undo" a delete with cascades
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to "undo" a delete with cascades
|
|
| dsfsdfs878@tiscali.co.uk 2005-08-30, 7:24 am |
| 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
| |
| Razvan Socol 2005-08-30, 9:25 am |
| 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
| |
| Erland Sommarskog 2005-08-30, 8:24 pm |
| (dsfsdfs878@tiscali.co.uk) 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@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
|
|
|
|
|