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

Add a Physical File to a Filegroup in SQL Server 2005

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

To add a SQL Server physical file

1. Click Target - SQL Server, Databases on the Model menu.

   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 the General tab.
5. Click New on the toolbar to add a new physical file to the File Group Membership grid.

   A new physical file with a default name is added.

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.

More information:

Define Physical Files for a Database in SQL Server 2005