Improve company productivity with a Business Account.Sign Up

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

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
0
lozza05
Asked:
lozza05
1 Solution
 
dosthCommented:
you cant change like that, you can keep the system dbs on the e:\ and change you database location to g:
0
 
lozza05Author Commented:
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.
0
 
TAB8Commented:
I am sorry to say ..  but you will have to reinstall SQL and restore your SYS and User db's
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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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