Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › Define a SQL Server Database › Define SQL Server Database Files

Define SQL Server Database Files

Use the SQL Server Database Editor to define the filegroups and logfiles for a database in a SQL Server 2005/2008 physical model.

To define SQL Server database files

1. Click Databases on the Database menu.

   The SQL Server Database Editor opens.

2. Select the database in the Navigation Grid for which you want to define files.
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.