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

Posted on 2010-09-22
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 95

Accepted Solution

John Hurst earned 250 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 95

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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.


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 95

Expert Comment

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

Author Comment

ID: 33743148
Thank you!

Featured Post

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

707 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