Altering Databases - Database Files Tab

Increases the size of the database by either increasing the size of one or more of the database files or adding new data files to the database.

If you use secondary data files, then you must increase the size of the primary data file only when the catalog that it contains has become too large. When the catalog has become too large, new SQL Server objects, such as tables, cannot be created until you increase the size of the primary data file.

When you use secondary data files, you cannot create more space for storing Microsoft Dynamics NAV data by just increasing the size of the primary data file. You can create more space for storing data by increasing the size of the secondary data files that contain Microsoft Dynamics NAV information. You can also add new secondary data files in order to store more data.

To open this window, on the File menu, choose Database, choose Alter, and then choose the Database Files tab.

Note

The first data file that is listed on the Database Files tab is the primary file.

See Also

Tasks

How to: Increase the Size of Database Files
How to: Add New Database Files
How to: Alter Databases

Concepts

Altering Databases - General Tab
Altering Databases - Transaction Log Files Tab
Altering Databases - Collation Tab
Altering Databases - Options Tab
Altering Databases - Integration Tab
Altering Databases - Advanced Tab