Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • 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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

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