Build Advice: Small Business Data Server

agnahc

Distinguished
Feb 21, 2010
9
0
18,510
Approximate Purchase Date: e.g.: Within a week

Budget Range: Flexible but around $1000

System Usage from Most to Least Important: Data sever, remote login, productivity/accounting software (MS Office, Quickbooks)

Are you buying a monitor: No



Parts to Upgrade: None

Do you need to buy OS: Yes

Preferred Website(s) for Parts: Newegg, Amazon

Location: Philly PA. (have a microcenter nearby)

Parts Preferences: none

Overclocking: No

SLI or Crossfire: No

Additional Comments: This computer will be on all the time. The main advice i'm looking for is the CPU. One hardrive is for the OS and software, the other two will be for data in a raid 1 configuration.

Here's what I have so far:

PCPartPicker part list / Price breakdown by merchant / Benchmarks

CPU: AMD A6-5400K 3.6GHz Dual-Core Processor ($65.23 @ Amazon)
Motherboard: ASRock FM2A75M-DGS Micro ATX FM2 Motherboard ($58.98 @ Newegg)
Memory: G.Skill Ripjaws X Series 8GB (2 x 4GB) DDR3-1333 Memory ($60.99 @ Newegg)
Storage: Western Digital Caviar Blue 500GB 3.5" 7200RPM Internal Hard Drive ($59.99 @ Newegg)
Storage: Western Digital Caviar Blue 500GB 3.5" 7200RPM Internal Hard Drive ($59.99 @ Newegg)
Storage: Western Digital Caviar Blue 500GB 3.5" 7200RPM Internal Hard Drive ($59.99 @ Newegg)
Case: Fractal Design Define R4 (Black Pearl) ATX Mid Tower Case ($109.99 @ Newegg)
Power Supply: Antec EarthWatts Green 380W 80 PLUS Bronze Certified ATX12V / EPS12V Power Supply ($48.98 @ Newegg)
Optical Drive: LG GH24NS95 DVD/CD Writer ($17.99 @ Newegg)
Operating System: Microsoft Windows 7 Professional SP1 (OEM) (64-bit) ($135.98 @ Amazon)
Total: $678.11
(Prices include shipping, taxes, and discounts when available.)
(Generated by PCPartPicker 2013-05-13 10:20 EDT-0400)

I'd appreciate any comments/suggestions. thank you!
 
Solution
Windows 7 should be able to handle those sizes of databases and connected users - however the operating system doesn't offer much in the way of security. Server 2008 offers more security - but the price is going to blow the budget. Costs are $600+ for the software.

As for the CPU/RAM/Hard drives - You should consider the WD Black drives for the data drives, and my suggestion would be to skip over the RAID configuration - as the size of the databases would be easily restored.

I would configure the server with 3 drives - a blue drive for the OS, and 2 1TB WD Black drives as the data drives. Use SyncBack Free to backup the data - it can be configured to run daily automatically (backup first drive to second drive). If one drive...

agnahc

Distinguished
Feb 21, 2010
9
0
18,510


File sizes are less then 100mb and won't be growing exponentially. At most there will only be 3 users accessing the file at any given time. There will be several backups including an offsite copy.
 
Windows 7 should be able to handle those sizes of databases and connected users - however the operating system doesn't offer much in the way of security. Server 2008 offers more security - but the price is going to blow the budget. Costs are $600+ for the software.

As for the CPU/RAM/Hard drives - You should consider the WD Black drives for the data drives, and my suggestion would be to skip over the RAID configuration - as the size of the databases would be easily restored.

I would configure the server with 3 drives - a blue drive for the OS, and 2 1TB WD Black drives as the data drives. Use SyncBack Free to backup the data - it can be configured to run daily automatically (backup first drive to second drive). If one drive fails, simply plug in another drive and copy the data. The 2nd drive is a full working copy of the original data.

 
Solution