Solved

MS SQL 2008 cluster question

Posted on 2011-03-11
4
213 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:EugeneZ
Comment Utility
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:EugeneZ
Comment Utility
pls post print scrn if you can
0
 
LVL 42

Accepted Solution

by:
kevinhsieh earned 500 total points
Comment Utility
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
Comment Utility
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

771 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now