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

Define Physical Files for a Database in SQL Server 2012

Use the SQL Server Database Physical File Editor to define a physical file with all the attributes that are needed for a SQL Server 2012 database.

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 physical files and click Files.
3. Click File Editor in the Database Logfiles section.

   The SQL Server Database Physical File Editor opens.

4. Select the physical file that you want to define and work with the following options:

   Note: Click New on the toolbar to create a physical file. Use the Enter filter text box to filter a large list of physical files to locate the one that you want to define.

   Name

   Displays the physical file name.

   Type

   Displays how the physical file is used.

   Note: This field cannot be changed in this editor.

   State

   Specifies the state of the physical file. If you select the state as Offline, the filegroup becomes inaccessible.

5. Click the General tab and work with the following options:

   File Name

   Displays the location of the physical file.

   File Size

   Specifies the initial size of the physical file. Enter a whole number (no decimals). You can use the suffixes KB (kilobyte), MB (megabyte), GB (gigabyte), and TB (terabyte).

   Default: MB

   Max Size

   Specifies how large the physical file can grow. Enter a whole number (no decimals). You can use the suffixes KB (kilobyte), MB (megabyte), GB (gigabyte), and TB (terabyte).

   Default: MB

   File Growth By

   Specifies how you expect the file size to grow. Select Value or Percent.

   File Growth

   Specifies the amount of space to add to the physical file each time the file grows. Use a numerical value with one of the following suffixes: KB (kilobyte), MB (megabyte), GB (gigabyte), or TB (terabyte) if you selected Value for the File Growth By option. Use a numerical value without a suffix if you selected Percent for the File Growth By option. A value of zero indicates that there is no automatic growth.

   Read Only

   Determines the read/write status of the physical file.

   Media Read Only

   Specifies whether the physical file is on read-only media when you select the check box.

   Sparse

   Specifies whether the physical file is a sparse file.

6. (Optional) Click the Comment tab and enter any comments that you want to associate with the physical file.
7. (Optional) Click the UDP tab to work with user-defined properties for the physical file.
8. (Optional) Click the Notes tab to view history information and view or edit user notes.
9. Click Close.

   The physical file is defined and the SQL Server Database Physical File Editor closes.

10. Click Close.

    The SQL Server Database Editor closes.