Database Properties (Files Page)

  • Article

Use this page to create a new database, or view or modify properties for the selected database. This topic applies to the Database Properties (Files Page) for existing databases, and to the New Database (General Page).

  • Database name
    Add or display the name of the database.
  • Owner
    Specify the owner of the database by selecting from the list.
  • Use full-text indexing
    Select to enable full-text indexing on the database. Clear to disable full-text indexing on the database.

  • Database Files
    Add, view, modify, or remove database files for the associated database. Database files have the following properties:

    • Logical Name
      Enter or modify the name of the file.
    • File Type
      Select the file type from the list. The file type can be either Data or Log. You cannot modify the file type of an existing file.
    • Filegroup
      Select the filegroup for the file from the list. The filegroup is PRIMARY by default. You can create a new filegroup by selecting <new filegroup> and entering information about the filegroup in the New Filegroup dialog box. A new filegroup can also be created on the Filegroup page. You cannot modify the filegroup of an existing file.
    • Initial Size
      Enter or modify the initial size for the file in megabytes. This defaults to the value of the model database.
    • Autogrowth
      Select or display the autogrowth properties for the file, which control how the file expands when its maximum file size is reached. To edit autogrowth values, click the edit button next to the autogrowth properties for the desired file, and change the values in the Change Autogrowth dialog box. Defaults to the values of the model database.
    • Path
      Displays the path of the selected file. To specify a path for a new file, click the edit button next to the path for the file, and navigate to the destination folder. You cannot modify the path of an existing file.
    • File Name
      Displays the name of the file.
    • Add
      Add a new file to the database.
    • Remove
      Delete the selected file from the database. A file cannot be removed unless it is empty. The primary data file and log file cannot be removed.

    For information about files, see Designing Files and Filegroups.

See Also

Other Resources

ALTER DATABASE (Transact-SQL)
Modifying a Database
sys.databases (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance