What is the cause of the SQlServer event caused by ApexSQLLog

This article mainly explains "what is the cause of the SQlServer event caused by ApexSQLLog". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the cause of the SQlServer event caused by ApexSQLLog".

Cause of the event: stop the SQLserver service and find a database in the source DATA database that is not the latest modification of the day.

Analyze the reasons:

There is a database MDF with the same name in the source DATA folder, but the time is not the time of the day. Under normal circumstances, the database service stops, and the last change time for all databases is the time when the service was stopped on the same day.

Puzzled, thinking that the database will not suddenly stop, resulting in the loss of the database.

Finally, close the ApexSQLLog tool and find that the database in the source DATA database that is not the time of the day has been modified to the time of the day.

Reattach the database and find that the database is normal.

Summary: ApexSQLLog tool in the analysis of a database, the database modification time is locked, at this time, stop the database service, will cause a database exception.

Correct solution: first close the ApexSQLLog tool, and then shut down the SQL service as needed.

Thank you for your reading, the above is the content of "what is the cause of the SQlServer event caused by ApexSQLLog". After the study of this article, I believe you have a deeper understanding of the cause of the SQlServer event caused by ApexSQLLog, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!