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

Define SQL Server 2012 Database Files

Use the SQL Server Database Editor to define the filegroups and log files for a database 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 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 Filegroups Editor to open the SQL Server Database File Group Editor and add or edit database filegroups.

   Database Logfiles

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

4. Click Close.

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