How to create a database (Enterprise Manager)

To create a database

  1. Expand a server group; then expand a server.
  2. Right-click Databases; then click New Database....
  3. 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.

  4. 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.
  5. 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.
  6. To specify how the file should grow, select from these options:
  7. To specify the file size limit, select from these options:

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.


See Also
Creating a Database Creating Filegroups

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.