SQL 1: Databases (Module 3)

Every SQL server database installation should consist of at least 3 files. The primary, secondary, and a log file.

Primary Data File - [blank_start].mdf[blank_end] Log file - [blank_start].ldf[blank_end] Secondary Data File -[blank_start].ndf[blank_end] Backup file -[blank_start].bak[blank_end]

This can be used to spread the data across multiple disks or to hold different types of data.

This is the starting point of the database and points to the rest of the files in the database.

Every database must have this because data is not written directly to the database file.

This can be handy for data management and backup tasks and can also be used to improve performance.

It is a named collection of data files.

This is like a cockpit voice recorder which stores each transaction processed by the SQL Server.

Commands are written here before they are executed on the database.

[blank_start]Checkpoint[blank_end] can be recorded to the log to aid in recovery to that point.

What are the different backup types? [blank_start]Full[blank_end] [blank_start]Differential[blank_end] [blank_start]File/File Group[blank_end] [blank_start]Transaction Log[blank_end]

This backups parts of the database that have changed since the last full backup.

This is a type of database that stores information about SQL Server as a whole. SQL Server uses these databases to operate and manage the system.

Check all the System Databases

This data type uses any combination of letters, symbols, and numbers.

Fields it to [blank_start]Columns[blank_end] as Records is to [blank_start]Rows[blank_end]