Solved

New drive in SQL-cluster

Posted on 2010-11-08
8
274 Views
Last Modified: 2012-05-10
Hi,

We were lacking diskspace on our SQL-cluster  (F-drive) and added a new one (H-drive).
Then we detached a database and now want to attach it. However, the H-drive is not visible when we choose "attach". I read somewhere you can set the default location of database so new database will go to the new drive, but this seems a bit tricky. Won't SQl look for all its database on the H-drive then?

I would prefer to just reattach from H-drive, moving database by database.
Thanks for your feedback.
0
Comment
Question by:exchangeexpertsdelijn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34084910
Is H: drive local?
0
 

Author Comment

by:exchangeexpertsdelijn
ID: 34084938
Yes, it's a local drive (SAN).
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34085409
The defalt database location is only for new databases.

In cluster adminstrator make the new h: a dependency of the SQL Server service. SQL will not allow you use drives that are not a dependency.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:exchangeexpertsdelijn
ID: 34090980
Thanks, are you absolutely sure about this? It's a production environment in which I cannot take any risk.
Is there any Microsoft-article 'bout it?

The reason why I ask, is what you mention about the dependency.
I don't thinks this is correct. If I look in the properties of our F-drive (on which current databases reside) there is no dependency set. This config is working for some years, we had some reboots, power cuts etc and the cluster came up without any issues.
0
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34091504
The drive needs to be a dependency of the SQL Server service not the SQL Service of the drive.

Here is an article telling you how to add a new disk.

http://sqllearnings.blogspot.com/2010/01/adding-new-disk-resource-to-cluster.html

Here is another link saying to add this as a dependency by a SQL Server MVP

http://social.technet.microsoft.com/Forums/en/winserverClustering/thread/60c6f061-050b-4756-ac77-fccb362e9d89
0
 

Author Comment

by:exchangeexpertsdelijn
ID: 34091720
Ok, so the dependency is set on the SQL-server.
However, we have to bring it down to set the dependency????
=> "Right Click on SQL Server, select Take Offline."

So, in order to add a new disk, we have to bring down our production SQL-cluster???
There should be another way, we cannot just bring down our cluster ....
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34091809
This is the way it works. There is no other way.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34094048
Are you happy with the proposed answer or do you require further assistance?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Suggested Solutions

Title # Comments Views Activity
Impove long SQL Stored Procedure Performance 14 79
Sql Query join multiple table and distinct records 7 32
Analysis of table use 7 63
Query to Add Late Tolerance 10 82
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

733 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