EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Data files


The Data files section of the Database Properties dialog allows you to specify that the disk files used to store the data portions of the database (data files) are defined explicitly, and fill the list of file items defining the data files for the primary file group.

 

To add a data file, right-click in the main working area and select the iconPlus Add file popup menu item.

To remove a data file, right-click the file in the list and select the iconMinus Delete file popup menu item.

 

Database Properties - Data files

 

 

The Name is a logical name used to refer to the physical file in all Transact-SQL statements. The logical file name must conform to the rules for SQL Server identifiers and must be unique within the database.

 

The File Name and Path is the name of the physical file including the directory path. The path must follow the rules for operating system file names.

 

File Group

The Primary file group contains the primary data file and any other files not specifically assigned to another file group. All pages for the system tables are allocated in the primary file group. User-defined file groups are any other file groups specified by the user.

Note: You can manage file groups for an existing database using the Filegroups section of the Database Properties dialog.

 

File size

Use the spinner control to specify the original size of the selected database file (in megabytes).

 

SQL Server 2005 (and higher) database files can grow automatically from their originally specified size. When you define a file, you can specify a file growth increment (in megabytes or in percent). Each time the file fills, it increases its size by the growth increment. If there are multiple files in a file group, they do not autogrow until all the files are full. Growth then occurs using a round-robin algorithm.

 

Each file can also have maximum file size specified. If CheckBox Unlimited is specified, the file can continue to grow until it has used all available space on the disk.

 

 


See also:

Information

Options

Log files

Filegroups

Filestream files and filegroups

Find Option