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.
Chris SlackIT ConsultantAsked:
Who is Participating?
 
Chris SlackIT ConsultantAuthor Commented:
Thanks for your reply, But I was able to condense it this weekend. It took all weekend to do but it did finish.

I did copy to a local machine and run all utilities only to find out the condensing the same thing.


Thank you for your reply.
0
 
JohnBusiness Consultant (Owner)Commented:
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.
0
 
Chris SlackIT ConsultantAuthor Commented:
Figure it out from reading quickbooks support forum.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.