Solved

New drive in SQL-cluster

Posted on 2010-11-08
8
272 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ms sql + top 1 for each customer 3 49
How to use TOP 1 in a T-SQL sub-query? 14 44
Unable to save view in SSMS 21 69
create insert script based on records in a table 4 21
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

770 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