Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Sql 2k5 and Win2k3 Cluster Resource Question

 
   Database Forums (Home) -> Clustering RSS
Next:  SQL 05 ENT Cluster: not enough disk space for dat..  
Author Message
Bill P

External


Since: Mar 08, 2005
Posts: 6



(Msg. 1) Posted: Thu Feb 14, 2008 9:33 am
Post subject: Sql 2k5 and Win2k3 Cluster Resource Question
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

I'm troubleshooting a related problem, and was hoping someone could give me a
complete list of the resources installed for SQl2005 a/p clustering, for both
the SQL and the cluster groups. Just want to eliminate the possibility that
something is missing.
thanks
Bill

 >> Stay informed about: Sql 2k5 and Win2k3 Cluster Resource Question 
Back to top
Login to vote
Justin Rich

External


Since: Jul 23, 2007
Posts: 17



(Msg. 2) Posted: Thu Feb 14, 2008 12:45 pm
Post subject: Re: Sql 2k5 and Win2k3 Cluster Resource Question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

depends on what you have installed.

You will for sure have SQL IP Address, SQL Network Name, SQL Server and i
believe the SQL Server Agent and SQL Server Fulltext are manditory... if you
have any other services installed (such as analysis services) you will have
a resource for each of those as well..

Justin


"Bill P" wrote in message

> I'm troubleshooting a related problem, and was hoping someone could give
> me a
> complete list of the resources installed for SQl2005 a/p clustering, for
> both
> the SQL and the cluster groups. Just want to eliminate the possibility
> that
> something is missing.
> thanks
> Bill

 >> Stay informed about: Sql 2k5 and Win2k3 Cluster Resource Question 
Back to top
Login to vote
Bill P

External


Since: Mar 08, 2005
Posts: 6



(Msg. 3) Posted: Thu Feb 14, 2008 12:45 pm
Post subject: Re: Sql 2k5 and Win2k3 Cluster Resource Question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you. What do you have in the CLuster group?
In my SQL group I have:
Analysis Services
Disk
DTC
IP address
Network name
SQL server
Server Agent
Server Fulltext

-b
"Justin Rich" wrote:

> depends on what you have installed.
>
> You will for sure have SQL IP Address, SQL Network Name, SQL Server and i
> believe the SQL Server Agent and SQL Server Fulltext are manditory... if you
> have any other services installed (such as analysis services) you will have
> a resource for each of those as well..
>
> Justin
>
>
> "Bill P" wrote in message
>
> > I'm troubleshooting a related problem, and was hoping someone could give
> > me a
> > complete list of the resources installed for SQl2005 a/p clustering, for
> > both
> > the SQL and the cluster groups. Just want to eliminate the possibility
> > that
> > something is missing.
> > thanks
> > Bill
>
>
>
 >> Stay informed about: Sql 2k5 and Win2k3 Cluster Resource Question 
Back to top
Login to vote
Justin Rich

External


Since: Jul 23, 2007
Posts: 17



(Msg. 4) Posted: Thu Feb 14, 2008 1:08 pm
Post subject: Re: Sql 2k5 and Win2k3 Cluster Resource Question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The way my working cluster is setup is i have "Cluster Group" which contains
the following.
Cluster IP Address
Cluster Name
Disk Q: (Quorum)
DTC

and my "Group 0" contains
Analysis Services
Disk G: (disk storage for sql)
SQL IP
SQL Name
SQL Server
SQL Server Agent
SQL Server Fulltext

"Bill P" wrote in message

> Thank you. What do you have in the CLuster group?
> In my SQL group I have:
> Analysis Services
> Disk
> DTC
> IP address
> Network name
> SQL server
> Server Agent
> Server Fulltext
>
> -b
> "Justin Rich" wrote:
>
>> depends on what you have installed.
>>
>> You will for sure have SQL IP Address, SQL Network Name, SQL Server and i
>> believe the SQL Server Agent and SQL Server Fulltext are manditory... if
>> you
>> have any other services installed (such as analysis services) you will
>> have
>> a resource for each of those as well..
>>
>> Justin
>>
>>
>> "Bill P" wrote in message
>>
>> > I'm troubleshooting a related problem, and was hoping someone could
>> > give
>> > me a
>> > complete list of the resources installed for SQl2005 a/p clustering,
>> > for
>> > both
>> > the SQL and the cluster groups. Just want to eliminate the possibility
>> > that
>> > something is missing.
>> > thanks
>> > Bill
>>
>>
>>
 >> Stay informed about: Sql 2k5 and Win2k3 Cluster Resource Question 
Back to top
Login to vote
MJboo

External


Since: Mar 18, 2008
Posts: 1



(Msg. 5) Posted: Tue Mar 18, 2008 6:38 am
Post subject: Re: Sql 2k5 and Win2k3 Cluster Resource Question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Is your Disk G: just acting as "quorum" for SQL or is you actual database
data on that Disk?

Also when installing SQL 2005 and Analysis services, did you install from
the virtual instance of your Cluster or did you install directly on your
passive node (node 1)?

I can't find any documentation that states whether to install from the
virutal server ( cluster instance) or on the Primary active node of the MSCS
cluster.

Thanks

"Justin Rich" wrote:

> The way my working cluster is setup is i have "Cluster Group" which contains
> the following.
> Cluster IP Address
> Cluster Name
> Disk Q: (Quorum)
> DTC
>
> and my "Group 0" contains
> Analysis Services
> Disk G: (disk storage for sql)
> SQL IP
> SQL Name
> SQL Server
> SQL Server Agent
> SQL Server Fulltext
>
> "Bill P" wrote in message
>
> > Thank you. What do you have in the CLuster group?
> > In my SQL group I have:
> > Analysis Services
> > Disk
> > DTC
> > IP address
> > Network name
> > SQL server
> > Server Agent
> > Server Fulltext
> >
> > -b
> > "Justin Rich" wrote:
> >
> >> depends on what you have installed.
> >>
> >> You will for sure have SQL IP Address, SQL Network Name, SQL Server and i
> >> believe the SQL Server Agent and SQL Server Fulltext are manditory... if
> >> you
> >> have any other services installed (such as analysis services) you will
> >> have
> >> a resource for each of those as well..
> >>
> >> Justin
> >>
> >>
> >> "Bill P" wrote in message
> >>
> >> > I'm troubleshooting a related problem, and was hoping someone could
> >> > give
> >> > me a
> >> > complete list of the resources installed for SQl2005 a/p clustering,
> >> > for
> >> > both
> >> > the SQL and the cluster groups. Just want to eliminate the possibility
> >> > that
> >> > something is missing.
> >> > thanks
> >> > Bill
> >>
> >>
> >>
>
>
>
 >> Stay informed about: Sql 2k5 and Win2k3 Cluster Resource Question 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL 2000 on Win2k3 Cluster - I am trying to install a named instance of SQL Server 2000 on an Active/Passive 2-node cluster on Windows 2003 Server. The installation proceeds until near the end, then I get the message: "The cluster resource failed to come online." When I...

Setup 2 WIN2K3 R2 Ent with SQL 2005 Ent in cluster - I am setting up 2 Windows 2003 R2 Ent servers with SQL 2005 Ent in a Cluster. Is it possible to run them in a NLB type config and write to the same disks on our SAN?

SQL server cluster on Win2k3. Does SQL need to be Enterpri.. - I have a SQL server cluster running on Server 2003. I am in the process of buying the SQL licenses. The difference in price between SQL Enterprise and SQL Standard are a couple thousand dollars. Does the cluster HAVE to be SQL Enterprise?

Cluster resource could not be found. - After a reboot of one of my node I am currently receiving the following message: The disk associated with the cluster disk resource 'Disk T:' could not be found. The expected signature of the disk was XXXXxxx. If the disk was removed from the serve...

How much disk for ms-dtc cluster resource ? - hello, I'm about to install a 2-nodes Windows 2003 Cluster, with 2 SQL Server 2005 instances: I've read in MS documentation that clustering MS-DTC is recommended, but I can't find how much disk space shoud I reserve for it group: can you tell me what...
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]