I have to replace a server. The system and user databases all reside on the
E: drive which is a SAN LUN. The method they want to employ is to remove the LUN from the current server and present it to the new server.
My concerns are that SQL Server is installed on the
C: drive which is local storage and will not move with the LUN. I will need to install SQL Server on the new server, and when I do the system databases will be created on the new server.
My questions are:
I know the user databases will need to be detached before moving the LUN, but what about detaching master, model, and msdb?
Assuming the system databases including master can be detached, after the LUN is associated with the new server, how would you handle the master, model, and msdb files on
E:with the LUN?
My thoughts were maybe choosing to install the system dbs on C on the new server and then after the LUN moves associate SQL Server with the location of the system databases on E and delete the ones on C.
I also thought about restoring the master db from a backup. How would you handle this?
This is SQL Server 2008 R2 SP2 10.52.4000 Enterprise non clustered.