Post reply

Primary Filegroup

  • July 26, 2016 at 10:01 am

    #400471

    Expert suggests to create a new filegroup when creating a new database and make that filegroup as default to place data files. Leave PRIMARY filegroup only for Microsoft System Objects.

    Would anyone please tell the reason why had they suggested like this?

  • July 26, 2016 at 12:41 pm

    #1892128

    There are a few reasons, but primarily this separates system objects from user objects. In case of corruption, or the need to restore a filegroup instead of the entire database, you can do that.

    I haven't typically done this in many smaller databases (< 100GB), and not sure I would. It adds a little complication and confusions when most of the time this doesn't affect how smaller databases work.

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

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