SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

Change the Collation Settings in MS SQL Server

This post will show you how to change the collation settings in MS SQL Server for specific database...

Resolve collation conflict

In this post I will show you how you can resolve collation conflict error...

Book: SQL Server 2008 High Availability

In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...

Why to recompile Stored Procedure

Generally, we create views and stored procedures (proc here after) ...

Showing posts with label sql active node. Show all posts
Showing posts with label sql active node. Show all posts

4/27/2009

Patching MS SQL Server Cluster

Ofent I found a question in a forums that "How to patch SQL Cluster" or "Patching SQL Server Cluster"

To answer this, there is nothing so special requirement but offcourse there is one thing one should consider and that is "Always patch active/primary node first". One should run SP setup on the primary node and it will get applied on the both node, we do not need to start/stop any services this is managed by SQL Server itself.

Refer section 3.2.5 Installing SQL Server 2005 SP2 on a Failover Cluster Instance