SQL redundancy question

Posted on 2007-10-16
Medium Priority
Last Modified: 2010-03-19
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?
Question by:4Beardog
LVL 18

Expert Comment

ID: 20089635
You can go two ways:
1. build a complete Windows cluster, including a SQL Server or
2. build two separate Servers, run SQL Server on both and mirror the database (you want a third very small SQL Server instance to fulfill the witness role in the mirroring scenario)

But you need the second machine in both scenarios.

Hope this helps ...

Accepted Solution

Crag earned 2000 total points
ID: 20092195
Two things to watch out for (out of the many):

1. A cluster typically needs to be built from the ground up as only specific hardware can be used. This might impact your existing system.

2. In a mirrored configuration the speed of the network connecting the principal and the mirror is critical to the performance of the mirror, especially in syncronous mode. I would always recommend a dedicated connection for the mirror running twice as fast as you need - which only testing will determine.

I prefer the mirrored config as it means you can have a completely seperate system in a different building or location and avoids the issue of the shared disk in a cluster. In a cluster the shared disk is still a Single point of failure.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question