Except for the ability to purge the audit trail, there is no system function to purge or archive transactions. Therefore, the database will grow forever.
PART A:
The database will become so large it is difficult to manage. The time needed to make backups and transfer those backups off-site will increase in indefinitely.
PART B:
Performance is negatively impacted by storing large amounts of unneeded data in the database.
PART C:
The SQL Express edition has a 10GB limit. Some customers can operate fine with this edition of SQL. However, once this limit is hit, CB comes to a halt without warning.
WORKAROUNDS:
(there are a few SQL scripts around that will clear out a few things, need to document and attach)
Except for the ability to purge the audit trail, there is no system function to purge or archive transactions. Therefore, the database will grow forever.
PART A: The database will become so large it is difficult to manage. The time needed to make backups and transfer those backups off-site will increase in indefinitely.
PART B: Performance is negatively impacted by storing large amounts of unneeded data in the database.
PART C: The SQL Express edition has a 10GB limit. Some customers can operate fine with this edition of SQL. However, once this limit is hit, CB comes to a halt without warning.
WORKAROUNDS: (there are a few SQL scripts around that will clear out a few things, need to document and attach)