How to Recover Deleted Records from SQL Table?
- This topic has 4 replies, 4 voices, and was last updated 7 years, 11 months ago by .
-
Posts
-
You can try 3rd party tools available in the market, which will allow you to recover your deleted records from sql server database file.
I can suggest you a sql recovery tool from http://www.systoolsgroup.com/sql-recovery.html
For further drilling down to know who deleted and who modified the database records, you need to take help of SQL Server log files. Logs files are stored in same folder as of master.mdf and having file extension as .ldf. Get a sql server log file reader to view logs and see who deleted and at what time.
Other tool to view sql server log files to view sql server database operations like modifying, deleting or adding can be downloaded from http://www.systoolsgroup.com/sql-log-analyzer.html
You can use this sample query to find out when the table was last updated.
SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,* FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID( 'DB_name') AND OBJECT_ID=OBJECT_ID('Table_name')What is gone is gone
Always use BEGIN TRANSACTION whenever running a update or delete, then COMMIT if successful or ROLLBACK if not.
- You must be logged in to reply to this topic.