Moving Database with more than 16 Files to another drive !!Urgent!!

• Abi-66064

  SSC Rookie

  Points: 25

  More actions

  October 19, 2004 at 12:47 am

  #163595

  Hi,

  Please let me know how to move database with more than 16 Files to another drive as sp_attach will not allow more than 16 files.

   

  Thanks in Advance,

  Regards,

  Abi

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  October 19, 2004 at 6:54 am

  #527163

  Use CREATE DATABASE ... FOR ATTACH see

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp

   

  Far away is close at hand in the images of elsewhere.
  Anon.

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  October 19, 2004 at 6:58 am

  #527164

  Another way is to BACKUP the db and use RESTORE ... WITH MOVE

   

  Far away is close at hand in the images of elsewhere.
  Anon.