Imnport data into file groups

• mrochber

  SSC Rookie

  Points: 29

  More actions

  October 4, 2002 at 2:00 pm

  #105280

  I'm using DTS (export) to transfer a database from one server to another. The source database has multiple file groups for tables and indexes. These file group exists on the destination server but all data and indexes are stored in the default file group. How can I insure that the reference to the proper file groups is exported and used in the new server?

  Motti

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  October 4, 2002 at 5:58 pm

  #437881

  Don't think you can do it. You may have to transfer the data into second server and place tables into different file groups.

  Why just use Copy Database Wizard, Backup and restore as well as sp_detach_db and sp_attach_db to transfer your database?