abc.mdf file in S:\drive
abc.ldf file in S:\drive
abc_2.ldf file in E:\drive
abc_2.ldf was created recently in E:\drive as a temporary measure due to insufficient freespace in S\drive.
Customer has given another logical drive called G:\drive which has ample space for growth.
I am going to move all the above datafiles (mdf and ldf) to this new logical drive.
Can I use deattach method and then move these files to G:\drive and then attach them back to the system ?
Do you thing there will be any complication in this process as to ldf currently located in S:\drive and E:\drive ? Intention is to move them all the newly created G:\drive
Thanks in advance.