Is it ok to delete a database mdf file from window explorer under the circumstance describe below?
It is during a restore process and the server doesn’t have enough space.
I have run alter db set single_user with rollback immediate, and will run restore from disk with replace.
Since that file is going to be replaced anyway, is it ok to delete it first then re-run above restore to get by insufficient free space issue?
Never done this way before, but logically it should seem OK.
What do you all think?