SQL Server database principles Reading Notes (2)-databases and database files

1. System database:

Master-System database;
Model-template database. All databases we create are Copy databases;
Tempdb-temporary database. After SQL Server is restarted, it will be re-created. You can create private (prefix #) and Global (prefix #) temporary tables on it;

Others-example database;

2. database files:

Each SQL Server database must span at least two files, one for data, index, and allocation pages, and the other for transaction logs. There are three types of data files: primary data files, secondary data files, and log files.

To facilitate database space allocation and management, You can merge multiple database files of a database into different file groups.

3. database backup and recovery:

Backup Type: Full backup, Incremental backup, and log backup;

Recovery mode: FULL recovery, BULK_LOGGED recovery, and SIMPLE recovery.