Discussion Locked

choosing a server

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i was asked to give a hardware solution for the employees database (SQL server7.0, about 50 users, 100 GB of data ), so i was wondering what kind of servers to get, how many to perform the recovery in case of a disaster, and backup suggestions

thank you

3 replies

by stillatit

For reliability, I like the Compaq machines. How much machine you buy will depend on the amount of activity you expect. If your 50 users will be hitting that database every minute, you may want multi-processors and maximum memory. If you only get a few thousand queries per day, you might get away with a single processor. You will want at least 256Mb, preferably more, in any case.

If this is a critical database, you should have it sitting on a hardware RAID-5 array.

The easiest backup is to get a tape drive big enough for your disks, with software which will drive it. Look at tape drives for DLT or AIT tape. Recovery of single files is simple. Recovery of a whole system (say, after a fire), involves loading the OS and tape software on replacement hardware, then reading the tapes. Note that your tape schedule should include tapes going off-site daily or weekly (depending on value of the data and your level of paranoia).

Good luck

by bob the builder

I have just recently installed a SQL 2000 box with W2K Adv Server. The recommendations for the hardware was: Dual 1Ghz or > CPUs, 2x9Gb SCSI Raid1 for OS and SQL app + Arcserve etc, 2x40Gb or > Raid1 for Data, 2x40Gb or > for Translogs and 2Gb RAM. Make the Data and Trans drives Dynamic so upgrading disk space is easier. This was a HP 3000r server with an Ultrium 215i Tapebackup unit which will backup 200Gb compressed, 100Gb un-compressed. The System/Boot is the whole 9Gb because 2Gb RAM equates to @ 3Gb pagefile.sys and a 4.2Gb system partition will not do. Microsoft recommend the two RAID-1 configs for Data and Translogs. The supplier of your server should be able to get another box if a major hardware failure occurs so the purchaseor lease of one box only should suffice. Hope this helps.

This discussion is closed to new replies.