Solved

The best way to shrink a Quickbooks enterprise 14 database

Posted on 2014-03-13
3
483 Views
Last Modified: 2014-03-31
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.
0
Comment
Question by:Chris Slack
  • 2
3 Comments
 
LVL 93

Expert Comment

by:John Hurst
ID: 39957516
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
 

Accepted Solution

by:
Chris Slack earned 0 total points
ID: 39957721
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
 

Author Closing Comment

by:Chris Slack
ID: 39966113
Figure it out from reading quickbooks support forum.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
QuickBooks 2013 3 805
Quicken 2014 Premier - Memorized Payee List empty 3 1,071
Sage Abra, Crystal Reports 1 525
GP 2013 Home Page 2 65
A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question