There is a limit and we found out the hard way. When running Quickbooks "Enterprise", and your company file exceeds 1.5GB, data corruption is INEVITABLE! Yes, so much for being 'Enterprise'. Quickbooks runs on a SQL Anywhere database and only a 32bit version. Nothing has changed over all the years.
Forget about using their build in Condense utility to shrink your file, it's not going to work unless you have a super clean database, and then it will still need to run for days depending on how you condense your data.
When you run a small to medium-sized business, QuickBooks enterprise is a risky accounting system as the risks for data corruption is great with only one recourse "Intuit Data Services" which takes multiple business days.
Yes, you need to treat your quickbooks database like a baby, run verify (every day? - every week?) to ensure there is no corruption you are bringing forth day after day and having to reenter SHOULD you figure it out.
Watch the rebuild results CAREFULLY! - EXPAND THE ERRORS AND PRINT IT OUT TO PDF!
When QuickBooks says it COULDN'T fix entries, CALL QUICKBOOKS DATA SERVICES. The next time you run the rebuild it will NOT show you these errors again and they are now part of your database.
Tips - Run Quickbooks in the cloud to prevent your system going down due to power outages and who knows what.
Have the server setup with rdp login for each user (users login to the same server where the database is located) It will prevent data corruption to a degree as there are no additional factors that could cause serious damage like lost connections when posting etc.
