question

nidheesh.r.pillai avatar image
nidheesh.r.pillai asked

Is it good practise to use Primary filegroup for all purposes?

Currently all our SQL Server objects are created on the PRIMARY filegroup (even on Production). I wanted to know what are the advantages/disadvantages in such a configuration? Is it a good practise? Is it better to employ different filegroups for different databases?
sql-server-2008filegroupprimary
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Tim avatar image
Tim answered
The default is primary and works for most all situations. Some situations warrant the creation and usage of secondary file groups. Most of the time I have encountered secondary file groups is for archiving data into secondary read only file groups or for separating indexes. Advantages of a single primary file group is it makes maintenance easier, disadvantages for very large databases is you have to restore the entire database versus being able to perform piecemeal backup and restores.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.