File Groups

In the legacy Synergetic solution, different databases had different strategies for growth and backup. In the new architecture, file groups are used for defining these strategies. While in the past, different databases and their associated log files could be stored on different disks, files can be used to separate parts of the database to be physically stored on separate disks.
File groups will allow Synergetic to determine which data objects are allocated to specific files.

File Group	Purpose
PRIMARY	This File Group must exist in SQL Server. Will primarily contain tables from the 'sys' schema.
FAST	For tables in dbo and finance schemas that are accessed the most. Intended for higher performance, the file(s) can be located on the fastest disk/hardware available at the school.
MAIN	The default file group for tables in dbo and finance. Intended for normal performance, the file(s) can be located on the standard disk/hardware available at the school.
ARCHIVE	For all tables in the preserved schema and for tables in the dbo and finance schemas that are accessed the least. Intended for disk/hardware with the slowest performance available at the school.
MEDIA FAST	For tables in the media schema that are accessed the most. Intended for higher performance, the file(s) can be located on the fastest disk/hardware available at the school.
MEDIA ARCHIVE	For tables in the media schema that are accessed the least. Intended for disk/hardware with the slowest performance available at the school.
SCRATCH	For all tables in the scratch schema.