SQL Log Rescue Version: 18.104.22.168
DB Recovery Model: Simple
Auto Shrink: On
Issue: a record has been inserted into the table and at a later time deleted. SQL Log Rescue has this transaction however the script does not recover all the data;
* Some date fields that are actually NULL have been returned by SQL Log Rescue as '19000101 00:00:00.000'.
* Some bit fields that are actually zero (0) have been returned as NULL.
* Some nvarchar fields that are actually NULL have been returned as ''.
* Some nvarchar fields that are populated have been returned as ''.
I'm presuming this may be related to the recovery model and data loss but how did that 01/01/1900 date get involved and nulls returned as blanks, etc., could there be an issue with SQL Log Rescue?
Extract of some of the values from an SQL Log Rescue UNDO delete script;
...'19000101 00:00:00.000', NULL, NULL, NULL, NULL, N'13', N'625 (PAL) SD ', N'', NULL, NULL, NULL, '19000101 00:00:00.000', NULL, '19000101 00:00:00.000', NULL,...