Microsoft SQL Server
Дата: 09.02.2013 14:39:59
I have a situation where I have a Storage Foundation cluster for MS SQL 2008 R2. I have mistakenly installed the Instance root directory on shared storage instead of local storage. Although the cluster functions without any issue, I wish to move the instance to local storage. The SQL binaries are on local storage (c:/program files).
Would anyone be able to help me with the easiest way to carry this out. I have researched a bit and have come to the conclusion that the easiest way to do this would be to install another named instance on local storage. Detach the DB from the original shared instance and attach it to the new named instance.
Any suggestions and ideas would be much appreciated. Thank you.