• oceanics8 - Friday, August 18, 2017 3:14 AM

    Thanks Anthony! It is mixed between D & E. You mean i need to modify the file location to my desire drive  first (E:\) and remove unwanted files in D:\ Would it cause any error?

    Run your alter database modify file commands to modify all files which are on D and modify them so they are on E.  Stop the SQL service, start the SQL service, upon starting it will create the missing files on the E drive.

    Once SQL has started ok, you can remove everything in D.