Saturday, July 28, 2007 10:02 AM
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.......
Saturday, July 28, 2007 2:18 PMModeratorthe 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
Saturday, July 28, 2007 4:50 PMModerator
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.
Sunday, July 29, 2007 3:54 PM
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.
Monday, July 30, 2007 9:22 AM
But i want to Know Some Free Data Recovery tools.
Could U Send Some Link Of That Types of tools Sites.
Tuesday, July 31, 2007 6:27 AMModeratorIt'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
Friday, August 03, 2007 6:58 PM
The only "free" data recovery tool I can think of is SQL Server's native backup and restore.
Sunday, August 05, 2007 11:35 AMModeratorinaddition 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....