lozza05
asked on
Changing SQL install drive letter
Hi experts,
I have SQL 2005 installed on a Windows 2003R2 server. During installation i made the mistake of pointing the installation to e:\ in stead of my preffered drive letter of G:\.
I am doubting a simple change of drive letter in the disc management will fix this issue as all the registry setting are set for E:\.
Any ideas how i can work around this?
Thankyou
I have SQL 2005 installed on a Windows 2003R2 server. During installation i made the mistake of pointing the installation to e:\ in stead of my preffered drive letter of G:\.
I am doubting a simple change of drive letter in the disc management will fix this issue as all the registry setting are set for E:\.
Any ideas how i can work around this?
Thankyou
you cant change like that, you can keep the system dbs on the e:\ and change you database location to g:
ASKER
Thanks, but the db locations are not important as they are hosted on shared storage.
The reason i need the SQL install location to be a different frive letter is for clustering. For example our primary SQL server is installed on drive g:\, and for clustering best practices (apparently) all other nodes in the cluster need to have the same drive letters.
The reason i need the SQL install location to be a different frive letter is for clustering. For example our primary SQL server is installed on drive g:\, and for clustering best practices (apparently) all other nodes in the cluster need to have the same drive letters.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.