Solved

Changing SQL install drive letter

Posted on 2008-06-11
4
373 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 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