How to "undo" a delete with cascades

dsfsdfs878

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

Aug 30 '05 #1

Subscribe Post Reply

3240

Razvan Socol

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

Aug 30 '05 #2

Erland Sommarskog

(ds********@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, es****@sommarskog.se

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

Aug 30 '05 #3

Similar topics

Replacing all entries with "Re:"

by: ss.wisch | last post by:

Ok here's the thing... I have a vBulletin forum database... there is a table in there called "post" which has all of my forums posts in it. What I have are many posts with regular titles like "Oh...

MySQL Database

How do we normally implement "Undo"/"Redo" function?

by: babylon | last post by:

any facilities in csharp that can help me implmenting undo/redo in my application? thx

C# / C Sharp

Visual C++ .NET: "unknown undo/redo error"

by: Alex L | last post by:

Hi To All! I just started to develop my applications in .Net. And I have a problem with undo option in the Visual Studio .Net: I can't to undo any text (code) (Ctrl+Z doesn't work!) And if I try...

C# / C Sharp

Session contents lost despite Session.Timeout = 3000; and <sessionState mode="InProc" cookieless="false" timeout="300">

by: Carpe Diem | last post by:

Hello I have an aspx page that loses Session("user") value after a few minutes even after I set <sessionState mode="InProc" cookieless="false" timeout="300"> in web.config and wrote function...

ASP.NET

How to "undo" a database delete

by: Morgan Bachu | last post by:

Hello everybody, I have an intranet application which is mostly a bunch of data editing forms. The database has about 20 tables all related together. Recently somebody deleted a "the wrong...

ASP.NET

How to write an "Undo" program in VB6

by: monkey3333sg | last post by:

I would like to add an "undo" button in my programme

Visual Basic 4 / 5 / 6

How to write an "Undo" program in VB6 ?

by: monkey3333sg | last post by:

I am programming some flow chart program using VB6... which is similar to Visual Logic software... I would like to add in "Undo" and "Redo" part...anyone can help? Thank you.

Visual Basic 4 / 5 / 6

Getting a "bogus" "The data has been changed" message from Access 2003

by: PW | last post by:

Hi, I have a form with unbound fields on it. The user selects a record from a recordset and I populate the unbound fields. When I try to change the unbound quantity text box, Access 2003 tells...

Microsoft Access / VBA

How to "UNDO" Form controls?

by: Nilam2477 | last post by:

I have a form with multiple TextBox controls and few other controls like comboBox, checkBox etc. I'm trying to implement Undo functionality for all the controls in the form. I'm using Push & Pop...

.NET Framework

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing