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

Define SQL Server 2005 Database Files

Use the SQL Server Database Editor to define the filegroups and log files for a database in a SQL Server 2005 physical model.

To define SQL Server 2005 database files

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

   The SQL Server Database Editor opens.

2. Select the database in the Navigation Grid for which you want to define files.

   Note: Use the Enter filter text box to filter a very large list of databases to quickly locate the one that you want to define.

3. Click the Files tab and work with the following options:

   Database Filegroups

   Specifies the filegroups for the database. Click the Filegroups Editor button to open the SQL Server Database File Group Editor to add or edit database filegroups.

   Database Logfiles

   Specifies the log files for the database. Click the File Editor button to open the SQL Server Database Physical File Editor to add or edit files.

4. Click Close.

   Database files are defined and the SQL Server Database Editor closes.