Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Re-assigning drive letters Expand / Collapse
Posted Wednesday, October 23, 2013 7:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 7, 2016 2:45 AM
Points: 35, Visits: 78
Hi, due to a data center requirement I have the need to do the following:-
current situation is
c:\ All system files
d:\ all SQL binaries
h:\ all MSD and NDF files (user and system)
o:\ all LDF files (user and system)
t:\ all tempDB files.

Data centre guys attach new LUNS called X; Y : Z:
I stop sqlservices. copy all the MDF, LDF, NDF from h: o: and t: to x: y and Z:
I reassign drive letters
h: -> p:
o: -> q:
t: -> r:
x:-> h:
y:-> o:
z: -> t:

restart SQL services.
Everything resumes and databases are online and working fine.
SQl just accepts windows presentation of drive volume to it? Correct? It does not do any bypassing of windows OS to the disk underneath?
I'm 99% sure this is all OK, and will test it beforehand, but just posting for comment. Thanks dave
Post #1507624
Posted Wednesday, October 23, 2013 1:06 PM


Group: General Forum Members
Last Login: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
that will work fine. As long as SQL is down whilst you do it and all the drives SQL sees end up with the same letters, this will work (i have done it myself).

Of course back up everything first and have a backout plan including making sure you know how to reinstall (you won't need to but be prepared)


Post #1507803
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse