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 745: 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 746: 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.