Post reply

Filegroups vs multiple files

  • January 30, 2014 at 9:39 am

    #289006

    Hi all

    Other that piecemeal restores what advantage is there in having multiple filegroups over having multiple files in a single file group?

    Thanks

  • January 30, 2014 at 11:07 am

    #1684790

    With separate file groups you can specify exactly where tables or partitions will be located.

    The probability of survival is inversely proportional to the angle of arrival.

  • January 31, 2014 at 3:09 am

    #1684965

    Objects are create on FILEGROUPS. This allows for them to be proportionally filled over multiple files depending on files sizes. This allows you to spread data reads/writes over multiple LUNs should you choose to.

    You cannot control which objects go in which files.

  • January 31, 2014 at 3:54 am

    #1684975

    Thanks both for the replies 🙂

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

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