Solved

Changing SQL install drive letter

Posted on 2008-06-11
4
364 Views
Last Modified: 2008-12-31
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
Comment
Question by:lozza05
4 Comments
 
LVL 15

Expert Comment

by:dosth
ID: 21766799
you cant change like that, you can keep the system dbs on the e:\ and change you database location to g:
0
 

Author Comment

by:lozza05
ID: 21766885
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
 
LVL 10

Accepted Solution

by:
TAB8 earned 250 total points
ID: 21827916
I am sorry to say ..  but you will have to reinstall SQL and restore your SYS and User db's
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now