How to create a database (Enterprise Manager)
To create a database
- Expand a server group, and then expand a server.
- Right-click Databases, and then click New Database.
- Enter a name for the new database.
The primary database and transaction log files are created using the database name you specified as the prefix, for example newdb_Data.mdf and newwdb_Log.ldf. The initial sizes of the database and transaction log files are the same as the default sizes specified for the model database. The primary file contains the system tables for the database.
- To change the default values for the new primary database file, click the General tab. To change the defaults for the new transaction log file, click the Transaction Log tab.
- To change the default values provided in the File name, Location, Initial size (MB), and File group (not applicable for the transaction log) columns, click the appropriate cell to change and enter the new 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 the file should be allowed to grow to, 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 Microsoft® SQL Server™ you are using.