Export (0) Print
Expand All
Expand Minimize

How to increase the size of a database (Enterprise Manager)

SQL Server 2000

How to increase the size of a database (Enterprise Manager)

To increase the size of a database

  1. Expand a server group, and then expand a server.

  2. Expand Databases, right-click the database to increase, and then click Properties.

  3. To increase the data space, click the General tab. To increase the transaction log space, click the Transaction Log tab.

  4. To add a new file, click the next empty row and, in the File name column, enter the file name that will contain the additional space.

    The file location is generated automatically and given the .ndf suffix for a database file, or an .ldf suffix for a transaction log file.

  5. To change the default values provided in the File name, Location, Space allocated (MB), and Filegroup (not applicable for the transaction log) columns, click the cell to change and enter the new value.

    For existing files, only the Space allocated (MB) value can be changed; the new value must be larger than the existing value.

  6. To specify how the file should grow, select from these options:
    • To allow the currently selected file to grow as more data space is needed, select Automatically grow file.

    • To specify that the file should grow by fixed increments, select In megabytes and specify a value.

    • To specify that the file should grow by a percentage of the current file size, select By percent and specify a value.
  7. To specify the file size limit, select from these options:
    • To allow the file to grow as much as necessary, select Unrestricted filegrowth.

    • To specify the maximum size to which the file should be allowed to grow, select Restrict filegrowth (MB) and specify a value.

Note  The maximum database size is determined by the amount of disk space available and the licensing limits determined by the version of SQL Server you are using.

See Also

Adding and Deleting Data and Transaction Log Files

Creating Filegroups

Expanding a Database

Show:
© 2014 Microsoft