I take a full backup of database say@ 8.00 am
and have inserted a 100 records @8.30 am
and have updated a data @ 8.35 am
now i have deleted around 10000 rows record @ 8.45 am
now I want to recover data till 8.44 am
First i will perform backup of my Tlog.
then restore my full back and then my tlog stopat=8.44 am
Now my doubt is
1.from where this 10000 records data are fetched from?is it from tlog or from ldf?
2.how sql engine will know the inserted data should be in mdf? means how Tlog is working internally to keep track this record?Like DCM in differential backup is there any algorithm is maintained?
THIS IS CASE 2:
1. restored my full back and then my tlog stopat=8.34 am
so want all the data i have updated will be rolled isn't it.
now my doubt is:
1.how sql engine get the old data or from where this old data is maintained and deleted the inserted value?