[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

The best way to shrink a Quickbooks enterprise 14 database

Posted on 2014-03-13
3
Medium Priority
?
525 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 98

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

656 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