versaSRS Knowledge Base

 

 


Database Creating Large Log File

Article ID: Q731530

Category: Software Solutions

The information in this article applies to:

  • versaSRS
  • Database Issues
The log file from the database is growing larger than the actual database, which can result in the disk being full and versaSRS stopping.
The log file needs to have a truncation happen instead of a shrink, truncations occur after a log backup, for a database with Recovery Mode set to Full it is always recommended to take regular backups otherwise the file will keep getting larger. 

Check if a database backup is being done in compliance with the maintenance plan in SQL which will truncate the log file upon completion. If this is not being done then perform a backup at least once so that the log file will be truncated down to a manageable size.
More information can be found on the Microsoft Website

Database Maintenance Plan Recommendations

Did the information in this article help answer your question?

Yes
No
Did not apply


Last Reviewed: 07/07/2022
Powered By VersaDev Pty Ltd Copyright 2022
Last Reviewed 07/07/2022

Print this page  Print this page
Click link to send to a friend  Send to a friend
Add to Favorites  Add to Favorites

Provided by
VersaDev Support Services