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

Define SQL Server Database Files

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

To define SQL Server 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.
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.