How to increase the size of a database (Enterprise Manager)
To increase the size of a database
- Expand a server group, and then expand a server.
- Expand Databases, right-click the database to increase, and then click Properties.
- To increase the data space, click the General tab. To increase the transaction log space, click the Transaction Log tab.
- 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.
- 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.
- 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.
- To allow the currently selected file to grow as more data space is needed, select Automatically grow file.
- 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.
- To allow the file to grow as much as necessary, select Unrestricted filegrowth.
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.