| Author |
Topic |
|
cz
Starting Member
19 Posts |
 Posted - 2011-05-04 : 16:49:11
|
| Hi,I would like to take SQL Server resource offline(in Cluster Administration) in a 2-node cluster. Do I have to stop the sql server services(Computer Management/Services) first?Thanks!!Cz |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cz
Starting Member
19 Posts |
Posted - 2011-05-04 : 16:56:01
|
| Thanks tkizer!!Just to confirm - so I dont need to stop sql server services while I take sql server resource offline in Cluster Administration? (since this is a Prod 24x7 environment, I have to be in caution..) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cz
Starting Member
19 Posts |
Posted - 2011-05-04 : 17:13:41
|
| Sorry not making myself clear.I added a SAN drive into the sql cluster, but in Cluster Adminisration the sql server resource has to be offline to add the new drive ( or is it?) Sorry not making myself clear.I added a SAN drive into the sql cluster, in Cluster Adminisration the sql server resource has to be offline to add the new drive ( or is it?) This is why I asked whether I can stop the resource to include the new drive in Cluster but keep sql services running, which seems impossible. Or is it possible to add a SAN drive in a cluster without downtime?Thanks Tkizer! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-05-04 : 17:18:56
|
| If your OS can "see" the disk in Disk Management then you can add it to the Cluster without having to take any resources offline. If you want to use it for SQL (Databases/log etc) and add it as dependency then yes you need to take SQL resource offline.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
cz
Starting Member
19 Posts |
Posted - 2011-05-04 : 17:22:56
|
| That's clear then.Thanks Tkizer for your time, you are awesome! |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-05-04 : 17:30:04
|
| If its SQL 2008 (and above) on Windows 2008 (and above) cluster then yes you can add the disk without taking SQL offline. However, if its SQL 2005 on Windows 2008 then I *think* you need to take SQL resource offline.. need to confirm this though as I dont have a SQL 2005 instance on a Windows 2008 cluster..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
cluster - take sql resource offline