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

Define SQL Server Files

Use the SQL Server File Editor to define the physical location of a file that is used in a database in a SQL Server 2005/2008 physical model.

To define a SQL Server file

1. Click Files on the Database menu.

   The SQL Server File Editor opens.

2. Select the file in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new file.

   • Name

     Displays the file name. You can change the file name in this field.

   • Type

     Specifies the type of SQL Server file that it is. Select the SQL Server file type from the drop-down.

3. (Optional) Click the Comment tab and enter any comments that you want to associate with the file.
4. (Optional) Click the UDP tab to work with user-defined properties for the file.
5. Click Close.

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