Recovery of a Table From SQL SERVER 2000

Question

Unfortunately a table is Deleted by me from my database.

Now How I can Recover that

I have no data and structure of that table Now.

It Was Very IMP. Table .

So Plz Help.......

Answer 1

the only option that comes to my mind is to restore the latest backup which was taken before the table was deleted.....it will definitely contain the datas you need........but b4 that take a backup of your db now so that if required you can restore from this backup......thanx

Answer 2

You 'may be able to recover the data from the log files (assuming you have a FULL recovery model in place) by using one of the third party Log exploration tools.

 

I suggest exploring Lumigent's Log Explorer, or ApexSQL's Log tools. I think that fully functional evaluation copies are available online.

Answer 3

Restore your last backup to another server or another database name. You can use DTS or scripting to move the table and data to the database where you dropped the table.

 

-Sue

Answer 4

Thanks Sir

Its work

But i want to Know Some Free Data Recovery tools.

Could U Send Some Link Of That Types of tools Sites.

Thanks

With Regards

Yogesh Kumar.

Software Consultant

New Delhi.

Answer 5

It's actually difficult to find one when you are looking for something "FREE." Third-party tools out thre have evaluation periods which you can try out

 

Answer 6

The only "free" data recovery tool I can think of is SQL Server's native backup and restore.

 

-Sue

Answer 7

inaddition to what i said earlier if you have sql 2005 you can also make use of Database snapshot.It is a new feature available in sql 2005 enterprise edition...........if you had taken a snapshot before dropping some records you can retrieve those records by restoring from the snapshot....