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
Solved

New drive in SQL-cluster

Posted on 2010-11-08
8
273 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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need help with a query 6 75
Unable to save view in SSMS 21 73
Find data in a column which is not in  a date format 29 35
Sql Server group by 10 42
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

790 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