You are here:
Computer Science/Raid
Advertisement
Question
Hi I am setting up an additional server as an application server and have five SCSI hard disks, 1 GB each. Performance isn't a significant concern but protecting the database that's stored on this server is critical. How can I configure the system to help proper startup, provide sufficient storage capacity, and protect the database from data loss?
Jessica:
Set system up with RAID 0 combination and also do regular backups of SQL Server data. You may want to MIRROR database if performance isn't an issue that way you have an immediate backup of data.
For further details read Database mirroring for your database and read up on setting up SCSI hard disks as RAID 0.
Kind Regards,
jeff
- Add to this Answer
- Ask a Question
| Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 10 | Politeness = 10 |
| Comment | Thank you very much for your help. | ||
Related Articles
Jeff Laatsch
Expertise
I can answer programming questions related to: C, C++, PHP, PERL, VB, SQL, ASP, JAVA, JS, XHTML, XML, CSS, PL/SQL, AWK, SED, VI Editor and if I don`t know the answer I have 20+ years systems experience as my resource. I can handle general questions in most areas of computer science including systems integration, API, networking related issues.
Experience
An accomplished WEB Master/Developer, Programmer Analyst, Systems Administrator with 12+ years of industry background in full system management and technical hardware/software support expertise including SUN, HP-UX, AIX, LINUX, and Windows NT,Win2000, 2003 with Active Directory: Well rounded in software engineering principles, requirements gathering, analyst, definition, system architectural design, OOA, OOD, UML, SEI-CMM and SDLC: Knowledgeable in Data Warehouse, Data Mart technologies, and experienced working with ORACLE databases utilizing ERP, SQL, PHP, PERL, C, C++, PL/SQL,SQL, JAVA, VB.NET, SOAP and other Dynamic WEB technologies: Analytical thinker and problem solver: Goal oriented professional who has a Masters in Computer Systems with emphasis in computer programming (C++ and Application Development).
Education/Credentials
City University, WA 12/03
Master of Science in Computer Systems
with Emphasis in Computer programming (C++/App Development)
Chapman University, WA 6/01
Bachelor of Science in Computer Information Systems
Emphasis in Computer networks and security
20+ years of experience in the Computer Science Industry
Awards and Honors
7/96,9/96,10/96,1/97,2/98,6/99,10/01,7/02,01/03,
Outstanding Achievement & Special Recognition
©2012 About.com, a part of The New York Times Company. All rights reserved.