Explain CREATE DATABASE syntax

Posted by

To view Verified answers click on the button below.

Many of us are used to creating databases from the Enterprise Manager or by just issuing
the command: CREATE DATABAE MyDB. But what if you have to create a database with
two file groups, one on drive C and the other on drive D with log on drive E with an initial
size of 600 MB and with a growth factor of 15%? That’s why being a DBA you should be
familiar with the CREATE DATABASE syntax. Check out SQL Server books online for more
information.