Moving database with multiple data files to a new location

• Bunmi

  SSC Veteran

  Points: 214

  More actions

  January 14, 2008 at 1:37 pm

  #202342

  How do I move a database with multiple data files to another drive on the same server?

  For example, my database consists of the files AA.MDF, AA_Index.NDF, AA_Secondary.NDF and AA_Log.LDF

  Any help will be appreciated.

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  January 14, 2008 at 2:54 pm

  #767885

  detach, copy files, attach them again.

• Bunmi

  SSC Veteran

  Points: 214

  More actions

  January 15, 2008 at 9:27 am

  #768217

  Thanks