Solved

MS SQL 2008 cluster question

Posted on 2011-03-11
4
246 Views
Last Modified: 2012-05-11
Why on one of my nodes its says "reserved" and doesnt show up under "My computer" and the other node it does? Just more out of curiousity
0
Comment
Question by:cjameson74
  • 2
4 Comments
 
LVL 42

Expert Comment

by:Eugene Z
ID: 35116164
could you please clarify clustering on what os it is set?

looks like you need check your clustering (stating from windows) setup
...e.g. if you have multy node one of node maybe reserved for fail over of another node..
anyway ... start from start.. and post what problemsdo you have ... more details ....
also use cluster admin to see avilable nodes ...
0
 
LVL 42

Expert Comment

by:Eugene Z
ID: 35116168
pls post print scrn if you can
0
 
LVL 42

Accepted Solution

by:
kevinhsieh earned 500 total points
ID: 35116231
Ifyou are talking about a disk, it is probably the cluster storage that is currently owned by the other active node.  A screen shot would help though to confirm.
0
 
LVL 13

Expert Comment

by:geek_vj
ID: 35126620
I believe you are talking about clustered disk which is showing as reserved. This indicates that to one of the nodes it will be accessible (aka reserved) and the other node cant access it. This is a common feature in Clustered environment. Hope this clarifies.

For any further queries, please revert.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question