Solved

rename a folder in storage disk

Posted on 2016-09-09
12
28 Views
Last Modified: 2016-11-02
Current we have one cluster storage disk (eg. MySite01) is in using by our SQL cluster, we want to rename it from MySite01 to Content10 (please see attached file)but there’re many DBs existing in this disk so I would like to ask you how to rename storage disk on Failover Cluster manager from Mysite01 to Content10 and then how to change db paths on SQL server disk drive because of if the storage disk path changes to Content10, databases within Mysite01 folder will be affected..could you please tell me how we should do on both side,Failover cluster management page and SQL server db paths?thanks
storage.jpg
sql.jpg
0
Comment
Question by:Teoman Sahin
[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
  • 6
  • 4
12 Comments
 
LVL 49

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
ID: 41790920
First stop SQL Server then you can rename the folder.
After that restart SQL Server (you'll have errors loading databases because the engine couldn't find the files) and then attach the databases providing the new locations of the files.
0
 

Author Comment

by:Teoman Sahin
ID: 41791061
I think first of all we should change the storage name on the failover cluster manager then second step,sql server server but ı could not find where to change so ı could not find any option for this
0
 
LVL 49

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
ID: 41791096
I think first of all we should change the storage name on the failover cluster manager
That's only a label. If you want to change there also you'll still need to stop SQL Server service first because of the dependencies. Try to change it with the Disk Management tool instead of Cluster Administration.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:Teoman Sahin
ID: 41791131
on the disk management,  I could not see any rename option to change the Mysite01
storage.jpg
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 41791147
Do you have admin access? The Change button is disabled.
0
 

Author Comment

by:Teoman Sahin
ID: 41791185
we  have admin rights on this server
0
 
LVL 49

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41791198
I don't have any cluster here to test but maybe you'll need to remove the storage from the Cluster resources to be able to perform the rename.
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 41812402
Teoman, any news on this issue?
0
 

Author Comment

by:Teoman Sahin
ID: 41812417
yes I agree with you so I suppose we will remove the storage from cluster resource but when we try this, it says It is in use and although I will remove the all depencies,I get the same error...if we remove it in any way,i don't know how I can add it again after renaming
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 41833802
Teoman, any good feedback?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

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