Recover delete data without backup
Question
All replies
-
My DB is open full recovery mode. I accidentally deleted the data from table. My DB don't have backup.
Can i recover delete data from Transaction log. (not use 3rd party tool)
Please help me.
Good day,
>> My DB don't have backup.
There are always these who learn in the hard way, and probably should not be in the position to get decisions or any management responsibility and since power and responsibility go together, they should probably not get any power in the system!
>> Can i recover delete data from Transaction log.
Most likely you can restore data from the log file as well as from the disk if not data was written on the same place.
The following post show for example how we find "Who deleted my record last time"
http://ariely.info/Blog/tabid/83/EntryId/154/SQL-Server-Who-deleted-my-record-last-time.aspxSame tools can be used to read the data from the log file.
With that being said, this require knowledge which someone who do not backup his database might not have. I am sorry but I cannot understand the meaning of "My DB don't have backup". I see this a lot and never understand it.There are third party application which do the work for you and present the data in a simple a readable way. Most of these even have the built-in option to restore deleted rows. To clarify! they do not restore anything to a point in time but getting the data and INSERT/UPDATE the rows according to the changes which made on the data
In addition to the option to use the log file if the issue related to removing a column for example, then you might be able to get the data of the column from the data file directly. Check the following post I wrote:
Ronen Ariely
[Personal Site] [Blog] [Facebook] [Linkedin]- Edited by pituachMVP Monday, September 2, 2019 3:28 AM
- Proposed as answer by Sabrina ZhangMicrosoft contingent staff Friday, September 6, 2019 7:18 AM
