Tables records deleted !!!
-
All records of some of tables in my database were deleted. Database is for a website on internet. Can anyone help me with some hints and a solution . This happened just today. Can I restore my lost records without a backup file ? Is there a way to find out how this happened ? (hacked ? exceeding db size limit ? ... )
-
All records of some of tables in my database were deleted. Database is for a website on internet. Can anyone help me with some hints and a solution . This happened just today. Can I restore my lost records without a backup file ? Is there a way to find out how this happened ? (hacked ? exceeding db size limit ? ... )
-
devboycpp wrote:
Can I restore my lost records without a backup file ?
No, however depending on how the data was deleted, it still may exist on the disk. You might want to see if there are any tools available to recover sql server data on a hard drive.
devboycpp wrote:
Is there a way to find out how this happened ?
There may be. I would start with any logs you have at your disposal. Check the Web Server logs, the SQL logs, Audit logs, the SQL Server Service logs. If you can not find anything there, look at how you insert, update and delete data from the affected tables for bugs. Check the web code for possible sql injection.
:)
-
All records of some of tables in my database were deleted. Database is for a website on internet. Can anyone help me with some hints and a solution . This happened just today. Can I restore my lost records without a backup file ? Is there a way to find out how this happened ? (hacked ? exceeding db size limit ? ... )
All depends on the recovery model. if you have a "full" recovery model then use a third party product to do if for you how do i recover data from sql server s log files[^]
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.