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.......
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|||
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.
|||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
|||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.
|||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|||
The only "free" data recovery tool I can think of is SQL Server's native backup and restore.
-Sue
|||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....
No comments:
Post a Comment