- Creating a Database in SQL Server 2000
- Creating a Database in Enterprise Manager
- About this Article
Creating a Database in Enterprise Manager
You can also use the SQL Server Enterprise Manager to create a new database. Follow these steps to create a new database:
1. Start the SQL Server Enterprise Manager by selecting Start, Programs, Microsoft SQL Server 2000, Enterprise Manager.
2. Connect to an instance of SQL Server.
3. Expand your Databases folder, as shown in Figure 2.
The right pane of the SQL Server Enterprise Manager shows the databases, and the pop-up menu lets you arrange icons or perform tasks.
4. Right-click either the Databases folder icon or in the whitespace in the right pane, and choose New Database from the context menu.
5. You should now be on the General tab of the Database Properties dialog. Specify a database name. (I used Croak.) Now switch to the Data Files tab (see Figure 3) to see the new database file named Croak_Data with an initial size of 1MB in the default ...\Data folder. In the File Properties section at the bottom of the dialog, notice that the Automatically Grow File option is turned on and that File Growth properties have been set. Also, the maximum file size is set to Unrestricted File Growth.
Use this tab to see the properties of a database, such as the name, size, and filegroup.
6. To change the properties of the database files, simply click the appropriate box and make your modifications. (I chose the defaults.) You can add additional database files if you go to the next box under File Name and add additional file properties.
7. Click the Transaction Log tab. Notice that it has a default name of Croak_Log and is 1MB.
8. Click OK when you are finished. You should now have a screen similar to Figure 4. If you don't see your Frogger, Leap, or Croak databases, right-click the Databases folder, and choose Refresh from the pop-up menu.
The new databases have been added.
NOTE
All the Create Database Wizard does is populate Enterprise Manager's Create Database dialog in multiple steps. So no further discussion of this wizard is needed here.