Link to home
Start Free TrialLog in
Avatar of Chris Slack
Chris Slack

asked on

The best way to shrink a Quickbooks enterprise 14 database

I have a company who's database is close to 2GB, I've tried to condense the database but it errors out with QuickBooks has stopped responding. Does anyone of way to shrink or copy the active data only. It looks like the option for period copy has been removed.
Avatar of John
John
Flag of Canada image

Make a local copy of the database (that is on a PC, not the Network Server). Open QuickBooks on this PC and attempt to rebuild the database. QB, File, Utilities, Rebuild.

See if it will rebuild. If it will, that will shrink it to the extent possible.

If this is successful, try to condense it again, but only try condense on the local machine. Do not do any of this work over a network connection.
ASKER CERTIFIED SOLUTION
Avatar of Chris Slack
Chris Slack

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Chris Slack
Chris Slack

ASKER

Figure it out from reading quickbooks support forum.