Solved

Swaping Drive Letters

Posted on 2012-04-02
4
386 Views
Last Modified: 2016-11-23
Good day Experts;

     I am in a process of a SQL Server 2005 SAN Migration ( SAN Storage (EMC CX500’s Fiber Channel) to our new SAN Storage Dell EqualLogic ISCSI SAN) ) on a Microsoft Windows Server 2003 R2 Enteprise x64 Edition (Service Pack 2) standalone server.

These are the drives I am working with:

Test Data (T) – SSMSQLWHS/TEST - current drives on old SAN
Test Logs (U) – SSMSQLWHS/TEST - current drives on old SAN
New T Drive Test Data (F) -  SSMSQLWHS/TEST - new drive provided by server admin (on new SAN)
New U Drive Test Logs (G)  - SSMSQLWHS/TEST - new drive provided by server admin (on new SAN)


My server admin is of sick so I am at the point in my procedure to bring the New drives (F) and (G) online

So using disk management I need to bring (F) and (G) drives to be my current drives but (T) and (U) can’t be deleted just in case I have to revert back.

Can you please provide step by step instructions  on how to achive this.....???

Pretty green on the operating side of things...........
0
Comment
Question by:algotube
4 Comments
 
LVL 15

Assisted Solution

by:achaldave
achaldave earned 50 total points
ID: 37797714
If data is not already copied to new drives then you need to stop sql services and copy data from old drive to new drives.
once you are done copying follow the steps in this article to change drive letters, change drive letters of old drives first and then change drive letters of new drives.
http://support.microsoft.com/kb/307844

Restart sql services or reboot server after changing the drive letters
0
 
LVL 3

Assisted Solution

by:unsatiated
unsatiated earned 50 total points
ID: 37797721
http://technet.microsoft.com/en-us/library/cc778404%28v=ws.10%29.aspx

CLick Start
Right click computer and select Manage
Find Disk Management under storage.
Right click on the disk you wish to initialize and you can create a new partition on the disk.
0
 
LVL 5

Accepted Solution

by:
ssujai earned 400 total points
ID: 37799458
Since you have mentioned the old and new Drive letters, I assume that the drives are already available, the required data is copied and the only thing left to do is to change the drive letters. In that case you can use the following procedure

Note: You may need to stop all relevant services before doing this. Also you may  receive warnings that changing the drive letter will cause programs to fail

Part1:

First we need to free up the old drive letters
Go to My computer->manage->disk management

Select  Test Data (T)->right click->Change drive letter and paths-> Select volume-> click change->Assign any of the listed  drive letters

Repeat the procedure for Test Logs (U)

Part2:
Assign the freed up drive letters to you new drives ie New T Drive Test Data (F) & New U Drive Test Logs (G)

- Select  New T Drive Test Data (F)->right click->Change drive letter and paths-> Select volume-> click change->Assign drive letter 'T' (It  will be listed in the free drive letters)

-Select  New U Drive Test Logs (G)->right click->Change drive letter and paths-> Select volume-> click change->Assign drive letter 'U' (It  will be listed in the free drive letters)
0
 

Author Closing Comment

by:algotube
ID: 37802401
Thanks everyone who responded..........
 ssujai excellent stuff thank you very much appreciated............
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Organizations create, modify, and maintain huge amounts of data to help their businesses earn money and generally function.  Typically every network user within an organization has a bit of disk space to store in process items and personal files.   …
I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

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

16 Experts available now in Live!

Get 1:1 Help Now