Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 42
  • Last Modified:

rename a folder in storage disk

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
Teoman Sahin
Asked:
Teoman Sahin
  • 6
  • 4
3 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Teoman SahinAuthor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Teoman SahinAuthor Commented:
on the disk management,  I could not see any rename option to change the Mysite01
storage.jpg
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Do you have admin access? The Change button is disabled.
0
 
Teoman SahinAuthor Commented:
we  have admin rights on this server
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Teoman, any news on this issue?
0
 
Teoman SahinAuthor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Teoman, any good feedback?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now