Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Re-assigning drive letters Expand / Collapse
Author
Message
Posted Wednesday, October 23, 2013 7:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 4:51 AM
Points: 10, Visits: 70
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:
and
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
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 11:57 AM
Points: 5,888, Visits: 13,062
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