Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 High Availability
»
Mount-point related error during SQL...
Mount-point related error during SQL installation on cluster node
Rate Topic
Display Mode
Topic Options
Author
Message
Marios Philippopoulos
Marios Philippopoulos
Posted Saturday, July 31, 2010 3:57 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 10:20 AM
Points: 1,825,
Visits: 3,483
We are getting the following error during SQL-2008 installation on a cluster node (active node) in an active-active-passive cluster configuration. We are using mount points in our implementation to increase the number of individual volumes that will host the database files. This occurs in the
Cluster Disk Selection
phase:
The mount point disk volume '\\?\Volume{fdba841d-9c06-11df-b213-0017a4770490}\' mounted at 'I:\$RECYCLE.BIN\S-1-5-21-1214440339-854245398-1801674531-11362\$RXP8E68\' is not a clustered resource.To continue, add the resource to the cluster, or remove the mount point to cluster the shared disk.
Anyone have any ideas how to resolve this?
__________________________________________________________________________________
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #961716
Jeffrey Williams 3188
Jeffrey Williams 3188
Posted Saturday, July 31, 2010 9:44 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Monday, June 10, 2013 12:13 PM
Points: 4,319,
Visits: 9,217
I am not sure about the reference to the recycle bin in the error - that seems a bit suspicious.
Is the I:\ drive a cluster resource? Is the mount point setup as a clustered resource and available to all nodes in the cluster?
Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Post #961766
mphilippopoulos
mphilippopoulos
Posted Saturday, July 31, 2010 9:53 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, January 23, 2012 12:02 PM
Points: 13,
Visits: 104
Jeffrey Williams-493691 (7/31/2010)
I am not sure about the reference to the recycle bin in the error - that seems a bit suspicious.
Is the I:\ drive a cluster resource? Is the mount point setup as a clustered resource and available to all nodes in the cluster?
Yes, I think the answer is yes to both questions. I didn't set it up myself, it was set up by our system administrator and SAN specialist. Is there any test I can run - perhaps using the Failover Cluster Manager tool - to confirm this?
Thank you for any hints on this, I'm new to the cluster implementation.
Post #961767
Jeffrey Williams 3188
Jeffrey Williams 3188
Posted Saturday, July 31, 2010 10:40 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Monday, June 10, 2013 12:13 PM
Points: 4,319,
Visits: 9,217
You can validate it yourself with minimal effort - RDP to the server and use the cluster administrator console (is this windows 2008 also, or 2003?). The administration of clusters had changed in windows 2008 and I'm not familiar with it yet.
What you want to do is validate that the drive has been added to the same resource group as SQL Server and that SQL Server is dependent upon that drive.
As for validating that the mount point is added to all nodes - you need to follow up with the SAN guys on that.
Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Post #961772
JohnnyDBA
JohnnyDBA
Posted Tuesday, December 20, 2011 8:22 AM
Old Hand
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334,
Visits: 708
Just FYI, I was experiencing the same error along with another error in
this post
that seem to be correlated. I posted the solution there.
Long story short, we ended up having to format the drive that housed the mount points then recreate them and that cleared up the issue.
Post #1224464
Perry Whittle
Perry Whittle
Posted Tuesday, December 20, 2011 11:02 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 4:39 PM
Points: 5,242,
Visits: 11,255
as already mentioned, see my article at
this link
for more info on setting up and using mount points for SQL Server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Post #1224647
hkamal.infoedge
hkamal.infoedge
Posted Tuesday, January 03, 2012 8:19 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Sunday, June 09, 2013 7:41 AM
Points: 142,
Visits: 153
Just check that the drive you are selecting for install should be in cluster and should not have any dependencies.
Post #1229302
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.