Creating Database

Creating Databases

When you create a database, you should understand what occurs during database creation, the options you have when you create a database, which options you can change after you create the database and how to view database properties.

When you create a database, SQL Server:
1. Creates a data file and a transaction log for that database.
2. Requires that the owner and creator of the new database have permission to use the master database, because information about each database in SQL Server is recorded in the sysdatabases table in the master database.
3. Allows you to define the name of the database, the properties of the database and the location of the database files
4. Uses a copy of the objects in the model database to initialize the database and its metadata. All options and settings applied to the model database are copied to the new database.
5. Fills the rest of the database with empty pages, except for pages that have internal data that records how the space is used in the database

Note:
You should back up the master database each time that you create, modify or delete a database.

When you create a database, you can specify the following options:
1. Primary File
2. Secondary Files
3. Transaction Log
4. Size
5. File Growth
6. Maximum Size
7. Collation