Show/Hide Toolbars

Jim2® Business Engine Help File

Navigation: Getting Started with Jim2

Managing Database Size

Scroll Prev Top Next More

The Jim2 database stores all emails, which means the database will grow in size, as well as the Jim2 backup files.

 

To reduce the file size of a Jim2 database, please consider the following:

1.Check your System Sent emails to see if there are emails that should be deleted. Consider deleting older emailed statements/invoices/purchase orders.

2.Delete emails that are no longer required. Deleted emails are moved to the System Deleted folder. Empty the System Deleted folder by selecting the emails (Ctrl+A for all emails), right clicking and selecting Delete from the menu.

3.Utilise email archiving.

 

SQL editions and versions influence the maximum database size, for instance the free version has a maximum size limit of 10GB.

 

Refer to https://msdn.microsoft.com/en-us/library/cc645993.aspx (copy and paste into your browser) for more information. Please liaise with your IT consultant regarding the appropriate version of SQL Server for your business.

 

Jim2 Server will log events to the Windows Event Log to indicate if backups are successful or not. These event logs should be reviewed on a regular basis.

 

Check your scheduled backups.

 

Most Jim2 sites will run a daily scheduled backup. If there is insufficient space on the hard drive where Jim2 is stored, this backup will fail. An easy check is to view the file size of the backup file – if it is 1KB, the backup file is probably incomplete.

 

On a regular basis, check your backups by restoring the most recent backup to a Jim2 Training database or similar.

 

The physical storage capacities of your hard drives need to be reviewed to ensure they can handle the growth in database size. This applies both to the drive where your database is stored and the drive where the backups are stored.