Post reply

Detach and Attach Database with Multiple FileGroups

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply