After the Welcome page of the wizard, the following page is shown:
The Create New Database Wizard - page 2 - login and primary datafile info
It displays the following things:
Server |
The server on which this database will be created. |
Database Name |
The name to use for the new database. |
Username |
The username used to create the database. This user will become the database owner. |
Password |
The password for the given user. |
Database file location |
The primary location of the datafiles, use the button to browse for a folder on the server. |
Transaction log file location |
The primary location of the logfiles, use the button to browse for a folder on the server. |
Collation |
The default collation to use for character columns. Using "[default]" means using the server-wide default collation. |
The Create New Database Wizard - page 3 - datafile properties
The Database files page let's you create additional datafiles and set the size and growth properties for each datafile. The filename of the primary datafile will be automatically set to <databasename>_Data.mdf
The Create Database Wizard - page 4 - logfile properties
The last page in the wizard shows the transaction log file properties - you can set the size and growth properties for each logfile. The filename of the primary logfile will be automatically set to <databasename>_Log.ldf
Use the Finish button to create your database.