Originally Posted by Bert
However, in our case it is already lost due to SQL Server being turned off. hence there is no way those transactions can get saved into AC database. I am sure you will disagree.

It isn't the best way to do a backup anyway.

How long does it take for information to get written into the SQL database for Amazing Charts? I don't stop the service and copy the *.mdf and *.ldf files until I have been logged out of AC for at least five minutes (have to get the thumb drives and access the server physically), and all my staff have been gone for more than 30 minutes. I would think that delayed writes to the database (on a system with only 6 users) have been made and I shouldn't have to worry about data loss.