What types of backup do you know in MS SQL Server? Tell me about full, incremental, and log backup.

In MS SQL Server, there are several types of backups:

1. Full backup — saves the entire database. It is the basis for recovery and contains all data at the time of creation.

2. Differential backup — saves only the changes made since the last full backup. It allows for faster recovery by applying the full backup first, then the differential.

3. Log backup — saves transaction logs, i.e., all changes that occurred after the last log backup. It allows restoring the database to a specific point in time.

Recovery scenario example:

• Restore the last full backup
• Apply the last differential backup (if available)
• Apply all subsequent log backups

This provides flexibility and minimizes data loss.