<div>
<a href="http://msdn.microsoft.com/en-us/library/ms188712.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms188712.aspx</a>
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to setup a redundant SQL system with two servers.<br />
<br />
I would like full redundancy so that if the main SQL server goes off-line then the other would take its place without any user interaction.<br />
<br />
Would the best option be Windows Server 2008 Ent in a failover cluster with SQL 2005?<br />
<br />
What would be the best option?<br />
<br />
Thanks,<br />
<br />
Ben
</div>
</div>


Hi,

I need to setup a redundant SQL system with two servers.

I would like full redundancy so that if the main SQL server goes off-line then the other would take its place without any user interaction.

Would the best option be Windows Server 2008 Ent in a failover cluster with SQL 2005?

What would be the best option?

Thanks,

Ben

http://msdn.microsoft.com/en-us/library/ms188712.aspx

SQL Failover Cluster - How To

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.