October 23, 2013 at 7:40 am
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
October 23, 2013 at 1:06 pm
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)
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply