MOVE MDF or LDF

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

durai nagarajan SSCoach Points: 15778 More actions · Answer 1

i hope this is not possible.

try backup and restore and then rename DB probably will reduce time but still may be data loss will be there if it is not detached.

Regards
Durai Nagarajan

george sibbald SSC Guru Points: 104210 More actions · Answer 2

It cannot be done without some downtime.

your options are detach\attach, restore with move option or alter database modify file with offline/online.

choose whichever is fastest for you. alter database is least intrusive.

---------------------------------------------------------------------