Database Size Maintenance

Back Top Previous Next

If Jim2 provides an error report along the lines of Could not allocate space for object, or similar. This is because the Documents and Emails database is full.

 

The size of the database files can easily be checked:

 

On the ribbon, go to Management > Reports > System > DB Statistics.

 

dbstatistics

 

The database will grow due to transactions, documents, reports and emails. The primary culprit will be email and, for this reason, there are a few things to consider:

Hardware capacity – for the databases, the Jim2 programs and the backup files. This probably requires a conversation with the company's IT team.

Email maintenancedeleting and purging emails that aren't required, archiving the emails or leaving all alone where the hardware capacity, RAM and processor facilities are suitable.

 

With email maintenance, normal deleting/purging of emails should be encouraged. Periodic clean out of sent purchase order emails and emails that are not associated with an object group (ie. not related to a job, quote or purchase order) is recommended. Purging emails results in the complete deletion of the email, and will be subject to security.

 

Additionally, Jim2 email is subject to archive rules, allowing archiving emails away from the Jim2 database and also restoring them.

 

Please follow these links for information on email archiving and managing the database:

Email archiving

Managing database size

 

Further Information

Backup Failure

Close the current window

Editing Core Fields in Stock

Error Messages and Logging

Font Scaling in Windows

Jim2 Help Not Working

Invoice Printing Issues

Jef Issues

Jim2 Connection Issues

Jim2 Freezes

Jim2 Server Scheduled Backup Fails

Jim2 Server Service Does Not Start

Jim2 Upgrade Fails

Outdated SQL Drivers

Printing Issues

What to do if Backup Drive is Full

System Locked by User

Active Job Unread Email