Partitioning in Microsoft SQL server
The partitioning in SQL Server is performed by a partition function and a partition scheme: database objects that define how the data should be divided and where it should be stored. These objects have to be defined by the database administrator prior to setting up the ImageMaster database model.
The following steps should be carried out, to set up an ImageMaster database model with enabled partitioning:
-
Creation of a filegroup and database files for each partition
-
Creation of the ImageMaster database model with enabled partitioning
The steps for partitioning reorganization are different from those on other databases. They are described in Modification of a partitioning function.