Small business server for files and QuickBooks

Magic Miguel

Member
Reaction score
13
Any recommendations? Tried piecing together an HP Micro Server from Ingram and D&H but it comes out to around $1100 with OS, RAID1 hard drives and 3-year warranty. Any other recommendations? Just file sharing and QuickBooks for a very small office, 3-5 users at any given time. Wanted to go with a NAS but can't do that with QuickBooks.
 
Just make sure you have them backup Quick Books on the workstation onto a jump drive in addition to whatever regular backup you are planning. QB makes a good accounting program but the software programming is not great and there are known issues with their data files with certain RAID controllers.
 
I'd kick up the hardware a bit more, something with Server 2012 Essentials, RAID 1/RAID 1 on 4x 10k SAS drives. Quickbooks needs some nut to run well, on both server side, network speed, and workstation side.
 
If you have 3-5 concurrent you'll probably need to be spending at least that much on the server. You need some decent disk performance for multiple access. Not so much RAM or CPU.

I don't think QuickBooks database loads into RAM like SQL, does it?
 
What would you recommend for server RAM in this case? My small clients typically have company files in the 100mb or less range. With current RAM prices I don't think I've spec'd anything smaller than 8GB, and that has been more than ample.

Don't mean to thread hijack, I think this stuff is still relevant to the OP. Plus it's always good to pick StoneCat's brain for these things. :)

Oh, forgot to ask- What server OS did you configure, Magic Miguel?
 
Without more info....I'd start with 16 gigs on the server, minimum. I see it was 3-5 users at any time...dunno if that's total users, or if that's just Quickbooks users and there are more "regular users" accessing other stuff.

Plus...often times once you put a server in the office, it's amazing how they can get filled up with other networked programs. Hence....shoot higher than you think for initial specs. Doesn't really cost much more money...especially when you factor in the lifespan of the server...usually minimum of 5 years.

Most clients would really be happier to spend 4,500 bucks on a server that they feel performs well throughout all 5 years...than to skimp a few hundred bucks up front..and end up with a server that doesn't perform well and starts bogging down at the 2 year mark.
 
Without more info....I'd start with 16 gigs on the server, minimum. I see it was 3-5 users at any time...dunno if that's total users, or if that's just Quickbooks users and there are more "regular users" accessing other stuff.

Plus...often times once you put a server in the office, it's amazing how they can get filled up with other networked programs. Hence....shoot higher than you think for initial specs. Doesn't really cost much more money...especially when you factor in the lifespan of the server...usually minimum of 5 years.

Most clients would really be happier to spend 4,500 bucks on a server that they feel performs well throughout all 5 years...than to skimp a few hundred bucks up front..and end up with a server that doesn't perform well and starts bogging down at the 2 year mark.
I was planning Server Essentials.

There is actually 2 main users at any given time working on QuickBooks, there are 2 others sometimes but they don't go on QuickBooks, but they will need access to file server. The current file server is a Dell OptiPlex but it went down and needed a new hard drive. So they felt the pain of being down without a computer/server for a few days.
 
Do you or your client foresee any considerable growth in the next 5 years? That would be an important consideration.

I've done two Dell T110 II servers for clients with low budgets but am not always so happy in doing so. Now I spec in a T320 as the starting point, and tend to shy away from clients that are too small. It seems like too much work for the money. Any how, the T110 II's have both been perfectly reliable and performance is fine for what they require.

It's sort of annoying though if you have them on a server maintenance plan. Installing patches takes a while, reboots take a while, moving files around can be slow, etc.
 
It's sort of annoying though if you have them on a server maintenance plan. Installing patches takes a while, reboots take a while, moving files around can be slow, etc.

MMmm Hmmm....yup.

Client whines about price...and the tech will propose some el cheapo server with sata drives...client bites...a "glorified desktop" is installed for a server. Client "thinks" he saved money. BUT....over the next 2-3 years...those "after hours" remote sessions the tech is doing to install updates, Exchange service packs, installing LOB apps, or doing <whatever> on the server...it takes SO.....MUCH-----LONGER. Reboots can be excruciating. My wife is calling me to bed..and I'm like..."hold on..just a few minutes...1x more reboot...."

...and 3 hours (cuz it's a glorified desktop server with sata drives 'n software RAID) later I drag my ass upstairs and she's fast asleep. Yup..hate that!

...and the client gets all of those billable hours...at "after hour rate". Those add up. So at the end of 3 years....total cost of ownership is typically (almost guaranteed) GREATER with the el cheapo server.

..unless you, the tech...like to volunteer your after hours time. :eek:
 
http://enterprisesuite.intuit.com/products/enterprise-solutions/technical/#top

These are server specs for newest QuickBooks enterprise (multi-user)

Bear in mind they are minimum specs and do not consider that the server may be doing other things!


Database Servers


  • Windows: natively installed & Windows 8, Windows 7 or Vista (SP1) with UAC on, Windows Server 2011, Windows Server 2008 R2, Windows Server 2008, Windows Server 2008 - Terminal Server Config., Windows Server 2003 (SP2), and Windows Small Business Server 2008
    Note: Windows Home Server Edition is not supported.
Hardware and operating system requirements (client and server)


  • 2.4 GHz processor minimum
  • System processor should support at least Streaming SIMD Extensions 2 (SSE2) instruction set
  • 2 GB RAM minimum
    • RAM requirements for multi-user setup
      • 5 users: 2-3 GB
      • 10 users: 3-4 GB
      • 15 users: 4-6 GB
      • 20 users: 6-8 GB
  • 4x CD-ROM drive required for CD installations
  • Display optimized for 1024 x 768 screen resolution or higher with up to 2 Extended monitors
  • Best optimized for Default DPI setting (96 DPI or 100%). Additionally, medium DPI (120 DPI or 110%) is supported to ensure an optimal experience for 110% scaling.
  • Windows:
    • U.S. version
    • Regional Settings are supported when set to English (United States) with keyboard setting to U.S. only
    • Administrator Rights required for the server computer when hosting Multi User Access
    • Natively installed
  • Disk space requirements:
    • 1.5 GB of disk space (additional space required for data files)
    • Additional software: 250 MB for Microsoft .NET 4.0 Runtime, provided on the QuickBooks CD
    • Additional requirements for Intuit Data Protect in QuickBooks Connected Services offerings
      • Require minimum 2.0 GB Ram
      • Twice the size of the largest File set to back up + 100MB or twice the size to restore. The space is only required from the work folder LocalApplicationData+"Intuit\Intuit Data Protect"
 
Yeah those system requirements are useless to me....only means it won't throw an error due to insufficient specs. But it may run like molasses.

System requirements for Windows 7
http://windows.microsoft.com/en-us/windows7/products/system-requirements
1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)
DirectX 9 graphics device with WDDM 1.0 or higher driver

Would you want to work on a P3 1.0 with 1 gig of RAM rig running Windows 7 every and and try to be productive? I'd rather paint the golden gate bridge with a toothbrush!
 
Any recommendations? Tried piecing together an HP Micro Server from Ingram and D&H but it comes out to around $1100 with OS, RAID1 hard drives and 3-year warranty. Any other recommendations? Just file sharing and QuickBooks for a very small office, 3-5 users at any given time. Wanted to go with a NAS but can't do that with QuickBooks.

So if this was my client I would ideally like to go with the Dell T110, 4 x 500GB in Raid 10, Server Foundation or Essentials, and 3 year warranty. 8GB is fine for this. That may be about $2000.

Now if that was an issue with price you can try to do a Dell T20. Most times you can find with the Xeon and 3 Year Warranty. You can do 2 SSD in Raid 1 on the built in Intel and find a OEM Server Foundation.

I just did the above for a client and it was fast. I have it backing up to a external 1 tb (image backup) and online backup. This is my standard approach.

Very fast. 7 users in QB, Files, and some basic LOB app.

Now if they bark at that price you are honestly left with doing a Dell Optiplex with a SSD and Windows 7. They get a 3 year warranty, you handle a great backup approach and they should be okay with that few users.

Is it ideal? Nope, but if the client doesn't see the value what can you do. As they grow they will need a server and this workstation can be setup as a workstation.

For that few users, if the machine failed, you could get them back up and running right away (have local backup as well as offsite).

I have some Dell T310 servers if you want to buy them, no warranty but real server specs.
 
Not to change the topic but why is everyone married to Dell servers? They cost more but your paying for a brand and Dell doesn't make a single component in their machines. I am not going to promote any other brands here but suffice to say many of us here can build a server as good or better for a lot less money.
 
Not to change the topic but why is everyone married to Dell servers? They cost more but your paying for a brand and Dell doesn't make a single component in their machines. I am not going to promote any other brands here but suffice to say many of us here can build a server as good or better for a lot less money.

Whole different topic and it's been covered in other threads...but I'll bite and toss out just a few of the many reasons.

*We also do HP Proliants.
*Also have done IBM X servers.

First, I'll preface it by saying I'm very comfortable with building my own custom systems...I used to build high end custom gaming rigs, and I used to build servers that hosted online games for clans, I'd have them in big data centers..and they were running some very popular game servers. One of them hosted an Unreal Tournament server that was in the NG Stats top 20 UT servers in the world list for around 3 years.

When I come across a client with existing home grown cloners....I make it clear that if I'm to be their ongoing IT support...that server will be replaced within the first year or so. I hate..hate ...hate...supporting cloners. I've wasted far too much time in my past troubleshooting wonky weird issues. I recall one law firm in the past, they had used a local IT shop that did cloners, including their server. Server would lock up randomly ...a couple of times a month. Tried this, that, the other...no luck. Spent crazy time on that. Eventually found out there was a weird compatiblity issue between the Adaptec RAID controller and the onboard NIC that the Soyo or Gigacrap motherboard had. Probably 3 people in the world had that combo and that problem.

I could type away for the rest of the day and fill the hard drives these forums are on with similar stories..but honestly it's boring.

*People that build cloners don't always fully and properly test the compatibility across components they use in the build. Tier-1 vendors do When you order up a Dell or HP or Lenovo server...you get a fully tested, compatible, certified stable system. There's no guesswork.

*Warranty. Typically at least 24x hours, overnight shipment. Typically options for 4x hours delivery! Typically options for onsite replacement of components (this rocks for my long distance clients).

*Guaranteed stock of parts for years down the road.

*Support for the server...1x stop support, quick support, very effective support.

*Importantly for your client....a system that is able to be supported by some other geek down the road if you get hit by a bus. It should be an important consideration done on behalf of your client. I think it's bad practice to select products that other techs in your area don't know or are unable to support or at least get support...it leaves your client screwed if you get hit by a bus.
 
Back
Top