Because of accidental operation, in Enterprise Manager mistakenly deleted the database table, then mistakenly deleted the table data what to do?
A lot of people's usual practice is to recover from the log first, if the recovery from the log is not possible from the MDF file itself.
The first thing to do when you delete data by mistake is to detach the database, stop the database service, and then copy the MDF and LDF.
Recover data from MDF files applied to the customer database a few years ago, but the recovery data from MDF has some limitations, MDF file is easy to be overwritten by other table records deleted records, there will be recovered from the MDF data is incomplete or data duplication phenomenon.
In order to better serve our customers, we have developed two tools, a tool for restoring with MDF, Http://www.greenxf.com/soft/93770.html#down
The other is a log file to restore the tool, if the log is complete, even without MDF can be perfectly restored
Recovery method for mistakenly deleting SQL Server database tables