How to: Increase the Size of Database Files

You can expand your Dynamics NAV SQL Server database by increasing the size of one or more of its constituent database files.


You must always make a backup of your database before expanding it. For more information, see Create a Full Database Backup (SQL Server).

To increase the size of a database file

  1. In the development environment, on the File menu, choose Database, and then choose Alter. The Alter Database window opens.

  2. Choose the Database Files tab.

  3. Select the data file that you want to expand.

  4. Choose the Size (MB) field and enter the new size.


    If the Unrestricted Growth option is not selected and the database has grown to its maximum size, then you can either select the Unrestricted Growth option or increase the maximum size of one of the secondary data files.

  5. (optional) To increase the maximum size of a data file, in the Maximum Size (MB) field, enter the new maximum size.

    You can also delete existing data files that are empty. The first data file that is listed is the primary file, and cannot be deleted.

See Also

Altering Databases - Database Files Tab