Creation of a filegroup and database files for each partition

One filegroup must be created per partition; each should contain at least one database file. This step can be performed in Microsoft SQL Server Management Studio by right-clicking on the database name and selecting Properties from the context menu:

Figure 853: Microsoft SQL Server Management Studio – database properties

The files and filegroups can be managed on the Files and Filegroups pages in the Properties dialog respectively:

Figure 854: Microsoft SQL Server Management Studio – adding a filegroup

Alternatively, these objects can be created using SQL statements ALTER DATABASE ... ADD FILEGROUP and ALTER DATABASE ... ADD FILE respectively.