restoring only 1 filegroup

• ksexton

  SSCrazy

  Points: 2790

  More actions

  June 11, 2002 at 12:47 pm

  #158590

  I have created a 50 GB table on it's own filegroup. I want to archive the filegroup and then drop the database. But I need to test attaching this filegroup to a new db if I ever need to restore this table. I have not gotten it to work. I have tried sp_attachdb and the single file one.

  -K

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 11, 2002 at 3:31 pm

  #430691

  Sorry, you cannot do this. All filegroups must be restored (not neccessary to be same path). You cannot restore a file group to another database.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)