versaSRS Knowledge Base

 

 


Maintenance Plan and Database File Size

Article ID: Q731195

Category: FAQ - Knowledge Base

The information in this article applies to:

  • versaSRS
  • Database Maintenance
If your maintenance plan is scheduled to run several times during the week the LDF file should be small. If the LDF file is large it suggests that the maintenance plan is failing or is not set up correctly.

Maintenance plan possibly set up incorrectly or not running as expected.

If the size of your LDF file is not reduced after running the maintenance plan a new LDG file may need to be created.

One way to do this is to detach the database and then delete the LDF file. When re-attaching the database, MS SQL should give you the option to create a new LDF file.

NOTE: When doing this it is a good idea to first stop the versaSRS Windows services, and make sure that you backup the .mdb and .ldf files in case there is a problem.

Once the database is re-attached, verify the data, by performing a count of the number of records in the following tables: tbl_Calls, tbl_CallAudit and tbl_CallAuditAttach.

Did the information in this article help answer your question?

Yes
No
Did not apply


Last Reviewed: 09/06/2022
Powered By VersaDev Pty Ltd Copyright 2022
Last Reviewed 09/06/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