Urgent Help on Accidental Row Deletion

Question

Urgent Help on Accidental Row Deletion

CDBA

Hall of Fame

Points: 3266
More actions
October 26, 2006 at 9:50 am

#61935

Hi,

I got an issue. By mistake one of my DTS got fired and execute a step as “delete table_name”. But I am not sure if the table was blank or seriously some row got deleted.
Can any one tell me how can I be sure if actually any row got deleted or the command was executed on a blank table with out restoring the database? I don’t want to restore the backup as the database is pretty big L
Thanks in advance.

Regards
Utsab Chattopadhyay

CDBA

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

The only way to do this, outside of a restore, would be if you have some sort of transaction log reader tool. There are a few tools like this out on the market.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

CDBA Hall of Fame Points: 3266 More actions · Answer 2

Thanks John. Any idea if we need to purchase that or any demo is available in net?

Thanks for the help.

Regards

Utsab Chattopadhyay

CDBA

SQLBill SSC Guru Points: 51440 More actions · Answer 3

You might search for Lugiment's Log Explorer. Some log readers must be running before you need them, but I think I've heard people say that Lugiment's works on any log file. I also think they have a trial version. You might give it a try. (Note: Some trial version log readers only work on the default databases - ie Northwind, Pubs)

-SQLBill

John Rowan SSC Guru Points: 56440 More actions · Answer 4

I've used Lumigent's Log Explorer (trial version) on a user database. You should be able to get yourself a free trial.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Lowell SSC Guru Points: 323518 More actions · Answer 5

note that the log readers are great, but only work if your recovery model is set to FULL; if it is simple, then there's no log to read, and thus not very useful.

start restoring on a different server/database, and compare the affected table(s) to see if there are differences;

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

CDBA Hall of Fame Points: 3266 More actions · Answer 6

Thanks guys for the lights & help..

I am downloading Lumigent's Log Explorer now for a trial. This issue is resolved now but I will like to deploy a log explorer in my critical boxes. Any guess if there is any security threat for deploying these tools? Or if I need to take some extra steps apart from configauing?

Thanks for the help.

Regards

Utsab Chattopadhyay

CDBA

Greg Charles SSC-Forever Points: 45403 More actions · Answer 7

We use Log Explorer and it has a pretty small footprint on the server. It installs a read-only extended stored procedure in the master database that can be secured for execution by a select few logins.

Greg

CDBA Hall of Fame Points: 3266 More actions · Answer 8

Thanks a lot

It seems that the trial version of Lumigent Log Explorer works only on sample databases. Could u please tell me if u have any idea on any other tool which works with out restriction with in the evaluation period?

Thanks in advance.

Regards

Utsab Chattopadhyay

CDBA

debrucer1 SSCertifiable Points: 5366 More actions · Answer 9

My first reaction when I saw this thread still active was "geez! he's been at this since last week... he should have just bought the Lumigent Log Explorer tool and been done with it.

Then I looked at their site and they don't even quote a price... you have to contact their marketing people so they can "understand your environment"... I read that is "see how far in your pocket they can get".

I do my best to NOT BUY from companies that don't post a price.

on the other hand... how valuable is your data? how valuable is your time?

You might lose the logs if you're not careful... and if there's referential integrity on your database, changes that take place are lible to invalidate whatever you recover, if you recover anything.

I wonder how much that dang tool costs? LOL

good luck!

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

CDBA Hall of Fame Points: 3266 More actions · Answer 10

Hi David

Actually the issue was already resolved [Luckily a quick restore was possible from disc]. But I was just wondering if it is possible for a safe guard for future. But, as you told already, I am also hesitating to ask my client to consider buying this stuff.

So requested in the forum if some one advise an alternate tool [Best if a low cost or free J ].

Thanks for the advise

Regards

Utsab Chattopadhyay

CDBA

Greg Charles SSC-Forever Points: 45403 More actions · Answer 11

We've used Lumigent Log Explorer for about 3 years and it's worked well for us. We recently increased the number of licenses and got a discount as a continuing customer. Though I don't have the price handy, I seem to recall the previous cost was about $1400 with support costing about $100 per year.

Another product that you might want to check out is ApexSQL Log. The company lists prices on it's web site (http://www.apexsql.com/), has volume discounts, and the 30 day trial version has no restrictions on the database.

I haven't used it, but I do use their Diff comparison product and I'm impressed with it's quality.

Greg