I had a rather interesting problem I written an application using Dev XAF for a client and the client had a program which I removed called Macrium reflect doing I assume a mirror copy from 1 hard drive to another. The first issue is the Macruim is a free version the second issue is the primary68716-sql-logs-2.log drive is an SSD and the secondary drive is a normal hdisk. Anyway what happen on the Sunday night the pc was shut down for some reason and in the morning it was restart naturally but for some reason all the SQL transaction for the day didnt commit to the database. I suspect Macruim locked the MSSQL file or the MSSQL backup stopped it not sure. However the the strangest thing happened all apps appeared normal but non of the changes committed to the database until at 17h26 the server restart however all the days transactions where lost.
Does anyone have any idea where I can look to see what happened or what caused the problem
The Server environment is to me is a little wrong they running MSSQL std 2017 windows 10 home 64 bit which is an issue and the database is 140gig contains quite a lot of pictures.
I have attached the MSSQL logs files for the day in question