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:
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