I'm pretty sure there have been tons of transactions occurred in the past two working days (5/11 and 5/12) but I just found out our production db physical file is currently stamped with the Modified date of 5/10/2015 12:06 am. How could that happen? Does it mean the SQL hasn't written anything back to the physical db file in the past two days??
Can someone help me understand this? Thanks.