MOVE MDF or LDF

• Dim Dim

  SSC Journeyman

  Points: 75

  More actions

  June 8, 2010 at 11:11 am

  #140771

  How can I move mdf or ldf from drive A to drive B without downtime(detachment)?

  Thank you in advance.

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  June 8, 2010 at 11:16 am

  #1177603

  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

  June 8, 2010 at 12:17 pm

  #1177629

  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.

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