Quickbooks 2010 slow access

Posted on 2011-05-12
Last Modified: 2012-06-27
We are running a 5 user version of QuickBooks Enterprise Solutions 2010 and we are experiencing serious slowness issues. We notice the issues the most when we back up the database. It take quite a while to go through the process of backing up. Preparing for backup is the longest process. About 20 minutes from start to finish.

Our data file is 187MB in size.
We are running on a Windows 2003 Server
Workstations are running XP Pro and AVG 2011 (I mention this because I guess this could be part of the problem??)
 As we are doing the backup, the server is idling and the hard drive lights occasionally flash - they aren't on steady

On the server there are two services showing up and both are running
QuickBooksDB19 and QuickBooksDB20

How do we completely remove QuickBooks so that we can do a clean install?

Now to add to this, before I removed QB off of the server, we started one workstation up and it told us that it was going to manage the database. Since we were going to temporarily remove it from the server, I chose that option for now. How will I change it so that I know the server is managing the databases after the dB engine is reinstalled?
Question by:johnbowden
    LVL 89

    Expert Comment

    by:John Hurst
    Lots here.

    1. Unless you have a reason (e.g. BigTime), QuickBooks should not be installed on the server, only the database engine.
    2. Go into the server and into Add/Remove Programs. Remove all instances of QuickBooks Server 20xx
    3. Make sure QB itself is uninstalled.
    4. Consider restarting the server (in an off moment)
    5. Install the version of server manager from the CD for QB2010. Start the CD, and at the install point, select just Server Manager. Make certain the server manager is installed on the same physical driver as the ledger is located.
    6. At the workstations, set each client so that it does not use Host Multi User Access (File -> Utilities).
    7. Make sure each client maps the QB ledger folder in the form NET USE Z: \\server\qbledgerfolder. You can use a script or Windows Explorer.

    That size of ledger should perform all right (never speedy). Try what I have suggestd and report back.

    ... Thinkpads_User

    Accepted Solution

    We run just the QB database engine on the server only
    I broke down and called Intuit support. They advised me to run a verify on the data. We did and it failed so then we ran a rebuild that that seems to have fixed the problem

    Author Closing Comment

    resolved myself

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
    You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now