Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more


Quickbooks Enterprise 2010-Any benefit to having company files on a dedicated file server?

Posted on 2010-09-22
Medium Priority
Last Modified: 2012-05-10
This is really probably a simple question for someone who is experienced with Quickbooks. I have a client running QBE 2010 with 3 PC's in a small office. He currently is set up in the "network hosting configuration" whereby one of his 3 PC's act's as the file server and hosts the company files. He would like to switch to a "client/server configuration" and put the Database Server Manager on his Windows Home Server(Windows Server 2003 under the hood).

I can't find any information as to if this is  beneficial and/or preferred over the way he has it set up now. Things are running smoothly and I am hesitant to switch unless there is some significant benefit to the client/server configuration.

Any input would be appreciated.
Question by:coptechs
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
  • 3
  • 2
LVL 98

Accepted Solution

John Hurst earned 1000 total points
ID: 33739504
If you only have 3 PC's and if it is running smoothly as is, then there is no particular benefit to change. If the file starts to bog down because of size, consider moving it at that time.

While I always like to do things optimally, this is one good case of "if it isn't broken, don't fix it" ... Thinkpads_User

Author Comment

ID: 33739547
"If you only have 3 PC's and if it is running smoothly as is, then there is no particular benefit to change. If the file starts to bog down because of size, consider moving it at that time."
So is file size really the only factor involved? I believe the company file is somewhere around 100 MB.
LVL 98

Expert Comment

by:John Hurst
ID: 33739577
100 Mb is not a big QB file. Enterprise is built for much more than that, and I see non-Enterprise machines over 500 Mb. Size is pretty much the biggest determinant.

When a file gets really large, you need it on a server, and more importantly, on a very fast server with very fast disk.

... Thinkpads_User
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.


Expert Comment

ID: 33739598
Moving servers is not likely to make a significant difference but may simplify or satisfy your users concerns. What would greatly help is to maximize the bandwidth to these clients and server. QB is not particulary bandwidth intensive but I have seen improvments on startup, saving, backing up, updates and some tasks when 10/100 was upgraded to gigabit lan even with less than ideal wiring.

IF this helps your client and soothes their concerns I would move them. Again those changes may be nearly unrecognizable but then plazebos work don't they.

LVL 98

Expert Comment

by:John Hurst
ID: 33740228
Thanks coptechs - I was pleased to assist. ... Thinkpads_User

Author Comment

ID: 33743148
Thank you!

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Learn about cloud computing and its benefits for small business owners.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

649 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