<div>
It is not possible to do an in place upgrade with out down time. 
</div>


It is not possible to do an in place upgrade with out down time.

<div>
Im still saying we cannot do that with out down time. the down time is minimal..<br />
<br />
//During the failover cluster upgrade, downtime is limited to failover time and the time that is required for upgrade scripts to run.//
</div>


Im still saying we cannot do that with out down time. the down time is minimal..

//During the failover cluster upgrade, downtime is limited to failover time and the time that is required for upgrade scripts to run.//

<div>
<div class="content wysiwyg-content">
Is it possible to upgrade a SQL 2005 cluster (2 nodes) to a later service pack without any downtime? How would it be done?<br />
<br />
Is it as simple as installing it on the passive node, failing over the cluster and installing it on what's now the passive node?
</div>
</div>


Is it possible to upgrade a SQL 2005 cluster (2 nodes) to a later service pack without any downtime? How would it be done?

Is it as simple as installing it on the passive node, failing over the cluster and installing it on what's now the passive node?

Installing a SQL 2005 Service Pack on a Cluster without downtime.

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

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.