Solved

Changing SQL install drive letter

Posted on 2008-06-11
4
391 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

730 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