Detach and Attach Database with Multiple FileGroups

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  April 22, 2008 at 4:36 pm

  #121481

  Hello Everyone

  I have a database with multiple FileGroups. I need to detach this database and move it to another drive, and then re-attach it. Is there anything special that I need to know before doing this. I have done this hundreds of times with a single filegroup database, but not in a long time with multiple filegroups. I cannot remember if there was anything that I have to do after the attach.

  Thanks in advance for your suggestions

  Thanks

  Andrew SQLDBA

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  April 22, 2008 at 9:53 pm

  #805857

  No special steps involved in this. Same as attaching a DB with a Single file group.

  Regards,

  Pradeep

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  April 23, 2008 at 9:45 am

  #806145

  Thanks for the info

  It has been so long since I worked with multiple file groups, I wanted a second opinion before starting.

  Thanks

  Have a good one

  Andrew SQLDBA