Database Reference
In-Depth Information
New Database
page, enter a name for the database and click
OK
.
Figure 11.70
shows
us creating a test database named test01db.
Figure 11.70
Creating a test database.
Now that we have our database created, we need to back up the database. Now would
be a good time to validate our database files and our log files were created in the
proper locations (K:\MSSQL\database\test01db.mdf and
L:\MSSQL\logs\test01db_log.ldf).
Figure 11.71
confirms our database and log files
were created in the proper location.