Well, if the server only needs to support 12 users it does not need to be powerful by server standards. A simple single socket budget quad solution should be enough for you daily usage. However, this all depends on the amount of users using the server at the same time and whether you plan to increase the workload over a longer period of time. If your requirements remain roughly static a single slot solution should be enough for you. However if the business is a growing one you might want to invest in a motherboard with more sockets for future expansion.
Also, you might want to consider alternative server options that may be cheaper to run for small business such as a server mac mini which is inexpensive for the reliablilty and security of such a SMB platform.
Just a few questions:
Just answering you questions, based on your current workload a single quad-core should be enough for your organization. Trust me, it will blow your Pentium 4 out of the water.
SAS disks will require a bigger investment but the motherboard will allow for drive hot swapping. FOr your business size, I recommend SATA drives, they are cheaper to buy and putting two into mirrored RAID should guarantee reliability. Try to stick to Hard Drives with long warranties, like the Caviar Black series.
Thanks for the advice so far.
You are right I meant to say RAID 5 or RAID 1.
Yes, the file and mail usage is low -- office paper shuffling.
Backup via swapping external drives daily -- no problem with that.
Storage -- the photo and video archive has grown and is now held on a workstation. That works fine.
On the file server we need less than 250g now so less than 500g in the future. A NAS could be used for files in the future if required.
The mail server software is MDaemon which I'm happy with. Considering changing at some point to Exchange but I simply don't have time to do that now. MDaemon uses less resource than Exchange -- should that be a consideration?
The key factor is speeding up this SQL database which we use for contact relationship management.
I suppose we could even keep the old server running with the files and mail while we setup the new server with the database.
As for me, I'm the accidental techie around here and I call in IT techs when required. I've asked two office networking pros and have received different recommendations from each one.
Well, trust me, when you do upgrade to a single quad the performance difference will be massive. I think you won't need anything more than a single socket CPU. Perhaps a Xeon quad-core with Hyperthreading?
I'd aim to find a motherboard that supports e-sata. E-sata is the fastest consumer interface for swapping external hard drives. It's as fast as SAS, just without the extra cost.
I'd say that 2 or 4 1TB drives in RAID 1 would be the way to go regarding the amount of data you use.
If you are happy with the current software, why change?