sql server clustering: taking offline a resource -- sql server clustering

taking offline a resource

liorhal NO[at]SPAM gmail.com
3/27/2005 4:29:04 AM

sql server clustering: what's the meaning of taking the sql-server resource offline ? what is
happning behind the scenes ? is it the virtual server offline ? is it
the specific node service offline ?

why is it that when i move the group (with these services offline)the
cluster admin doesnt restart them ? why bringing them offline doesnt
cause a failover ?

what is the different between 'take offline' and 'initiate failure' ?

is there a scenario when one of my system resources get offline
(because of some failure) and the cluster admin doesnt initiate
failover ?

thanks

Re: taking offline a resource

Mike Epprecht (SQL MVP)
3/27/2005 4:25:27 PM

Hi

online = in service
offline = out of service

Taking a resource offline is the same as stopping it. Taking a resouce
offline will not initiate a failover as the resource gets marked as offline.

Initaite failure takes the resource offline, but does not mark it offline,
so the clustering software in Windows detects the 'failure' and attempts to
bring the resouce up on another node.

Read
http://download.microsoft.com/download/0/a/4/0a4db63c-0488-46e3-8add-28a3c0648855/ServerClustersArchitecture.doc
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/clustering/sercsfaq.mspx

--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]