The Bottom Line

Create new databases. Creating new databases is a common and fundamental operation. Understanding what happens when a new database is created is a critical step.

Master It What system database is used as a template when creating a new database on SQL Server? How could you create an object that would exist in any new database on the SQL Server?

Plan databases. Adequate planning for user databases is very important. From choosing the appropriate recovery model to properly placing files, these choices will prepare the database for future operations.

Master It What is the most appropriate recovery model for a mission-critical database that needs the ability to restore to a point in time?

Discover information about existing databases. There are many ways to retrieve information about existing databases and their files. Management Studio can be an easy place to view information about individual database options; however, it's important to remember that this information can be retrieved using system catalog views.