SQL redundancy question
Posted on 2007-10-16
I have a 64 bit SQL 2005 server that is running our mission critical program. I back it up every night but if something bad happened we could loose tens of thousands of dollars per hour until it's back up.
I have some money and approval from the suits to build a redundant system. I planning on buying another server and sql 2005 and have the Database Mirroring and Failover Clustering configured to always have the system up.
My shares are in a DFS setup and it's working very well.
Is my proposal to build a whole new server the best solution? Is there a better program to replicate the information between servers? Can I run the SQL instance in a DFS namespace?