Database creation is a relatively straightforward operation that can be performed using T-SQL statements or the Enterprise Manager. Because the data and log files are created at the time the database is created, the time it takes for the database to be created will be dependent on the size and number of files specified when you create the database. If the disk space is insufficient to create any of the files specified, SQL Server will return an error and none of the files will be created.
Using the Create Database Wizard
The Create Database Wizard will take you step by step through the database creation process. This wizard can be accessed through the “magic wand” icon on the Enterprise Manager toolbar, from the Wizards menu ...