Re: Question on SQL Cluster Resource Groups
- From: "Linchi Shea" <linchi_shea@xxxxxxxxxxx>
- Date: Sun, 16 Oct 2005 23:24:41 -0400
You have a couple of options, and I'm sure different people may have
different opinions w.r.t. their pros and cons.
Option 1:
Move the resources from group 1 into the second group, and edit the
dependencies property of your virtual server to include the disk resources
you mentioned. In order to protect the HA of your SQL Server instance, you
may want to edit the advanced property tab of the resources--moved over from
group 1--so that their faulire doesn't affect the group.
Option 2:
Keep the groups as they are. Create a file share resource(s) in group 2, and
use the file share via the virtual server. I don't know the nature of your
particular virtual server, so I'm not sure this works for you.
Personally, I prefer to keep the SQL Server group clean, and will try very
hard to question any attempt to include additional resources in that group.
However, in your situation you already have a bunch of non-SQL Server native
resources in the SQL group so adding a few more may not do a great deal more
potential harm (of course that all depends on the details of the virtual
server in question.)
Linchi
"John - PDX" <JohnPDX@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D5396113-A4A6-4EA3-973F-B4CBF2021CDB@xxxxxxxxxxxxxxxx
>I have a sql cluster with my virtual server name, IP address, etc. in one
> group. In the other group I have my sql instance, san attached disk
> resources, sql agent etc. In this second group I also have a ftp server
> that
> utilizes the vbscript for fail over and uses a san disk resource.
>
> The problem I have is if the second group fails over say, due to a sql
> server error which has happened, then my ftp site dies as users put to the
> ftp site via the name / ip of the virtual server but then the virtual
> server
> cannot see the disk resources that are part of the second group.
>
> Is there any issues with putting the virtual server name & ip address in
> the
> same group with sql, sql agent, disk resources, etc.? In essence, putting
> everything in one group.
> --
> Thanks in advance,
> John
.
- Follow-Ups:
- Re: Question on SQL Cluster Resource Groups
- From: Anthony Thomas
- Re: Question on SQL Cluster Resource Groups
- Prev by Date: How to change the Cluster service(O/S cluster) account password ?
- Next by Date: Re: How to change the Cluster service(O/S cluster) account password ?
- Previous by thread: How to change the Cluster service(O/S cluster) account password ?
- Next by thread: Re: Question on SQL Cluster Resource Groups
- Index(es):
Relevant Pages
|
Loading
