Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2012 Property Editors › Define SQL Server 2012 Database Files › Add a Physical File to a Filegroup in SQL Server 2012

Add a Physical File to a Filegroup in SQL Server 2012

Use the Files tab in the SQL Server Database Editor to add a physical file to a filegroup in a SQL Server 2012 physical model.

Follow these steps:

1. Click Model, Target - SQL Server, Databases.

   The SQL Server Database Editor opens.

2. Select the database in the Navigation Grid that contains the filegroup to which you want to add a physical file and click the Files tab.
3. Click the Filegroups Editor icon.

   The SQL Server Database File Group Editor opens.

4. Select the filegroup in the Navigation Grid to which you want to add a physical file and click General.
5. Click New in the File Group Membership section to add a new physical file.
6. Change the default physical file name to a name suited to your modeling environment.
7. Click Close.

   The physical file is added to the filegroup and the SQL Server Database File Group Editor closes.

8. Click Close.

   The SQL Server Database Editor closes.