Planning - Good method for Quick recovery of MS server 2008 with SQL database in event of total server failure?
Posted on 2015-01-28
I have a local MS 2008 server running a SQL database. It is running RAID 5 with SAS drives. I have machinery that is dependent on this server to have high availability. If this server has a total melt down (failed motherboard, lightening strike, flooding, etc) after 2 or 3 hours it will start costing me $1,000 + per hour in lost productivity. I have another building that can house a 2nd server within 200 feet and can connect it together with Ethernet cable or fiber and house a 2nd server. Our internet connection is slow DSL. What are some solutions please? (mirrored servers or ???) All information and detail is appreciated.