<div>
See if this url helps you with linking both servers together.<br />
<a href="http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1262968,00.html" rel="ugc">http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1262968,00.html</a><br />
<br />
For the DNS question:<br />
You can take a look at DNS Round Robin or Virtual IP for your SQL Servers. But do note that you might want to test your application against both servers for compatibility.
</div>


<div>
both servers will host the same data but i dont want to buy additional licensing for more processors for sql 2005
</div>


<div>
<div class="content wysiwyg-content">
I have one server running SQL Server 2000 and another server running SQL Server 2005 both are enterprise edition. I was wondering what options do I have for redundancy/failover between the two versions? I'm also looking for some kind of guide so I can figure out how to point all of my DSNs to one address called SQLServers and have that point to either server so if one server is down, the other server will take over without any downtime.
</div>
</div>


I have one server running SQL Server 2000 and another server running SQL Server 2005 both are enterprise edition. I was wondering what options do I have for redundancy/failover between the two versions? I'm also looking for some kind of guide so I can figure out how to point all of my DSNs to one address called SQLServers and have that point to either server so if one server is down, the other server will take over without any downtime.

Redundancy/Failover options for SQL Server 2000 &amp; 2005

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 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Redundancy/Failover options for SQL Server 2000 &amp; 2005

Redundancy/Failover options for SQL Server 2000 & 2005