20 pts.
 RAID configuration
I am setting up an additional server as my application server. I have five SCSI hard disks, 1 GB each. The database is projected to grow to nearly 3 GB. How can i configure the system to help proper startup, provide sufficient storage capacity, and protect the database from data loss? Can anybody help me please

Software/Hardware used:
ASKED: July 15, 2009  6:57 PM
UPDATED: November 16, 2009  6:56 PM

Answer Wiki:
1GB drives are extremely small these days. You can get USB thumbdrives larger than this. You will need a system that will support a RAID (redundant array of inexpensive/independent disks). There are different raid types that can be implemented but with 5 drives, you should consider RAID 5. See the RAID5 section in this SearchStorage article on RAID. There are also some considerations about dividing out the OS, page file, log files & database files. Here's a sample of some considerations on database storage design on SQL servers. In the IT trenches? So am I - read my IT-Trenches blog. -- Is that GB a typo? I would configure RAID 1/0 with 4 disks, and leave the 5th as a hot spare.
Last Wiki Answer Submitted:  June 11, 2013  2:36 pm  by  Michael Tidmarsh   14,060 pts.
All Answer Wiki Contributors:  Michael Tidmarsh   14,060 pts. , Labnuke99   32,735 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _