OK, I think I have finally settled on upgrading to 2005 from 2000. My sysadmin is working on getting a SAN setup, but then he is leaving the company in a month. So, I have two issues. One, would it better to virtualize my database and create a cluster on 2 different servers using the SAN for the data, or should I stick with a standalone machine (Super Micro with dual AMD Opteron 6168s, a 3Ware RAID card, 24 GB RAM and (and here is the second question) a number of drives for a RAID 10 array)? If I go with a standalone machine, are the Seagate Constellation drives (7200 RPM, 64 MB cache, 6.0 gb/s SATA enterprise level) in a RAID 10 array for data, RAID 1 for OS and logs a good option? If I go with the stand alone machine, would it be better to go with replication or log shipping for keeping my backup server ready? The machine is our CRM and our e-commerce database. we don't handle the e-commerce internally, but the keygen requests are fulfilled by this machine as well as the CSRs and TSRs using this machine in all of their customer interactions.
Thanks for your input,
wb
Thanks for your input,
wb
