Backup and recovery refer to the process of creating copies of data (backup) to prevent data loss and restoring data (recovery) in case of system failures, corruption, or accidental deletion.

Explanation:

• Backup ensures a copy of data is available for restoration.
• Recovery is the process of restoring lost or corrupted data.
• Types of backups:
  • Full Backup: A complete copy of the database.
  • Incremental Backup: Only changes since the last backup are stored.
  • Differential Backup: Stores data changes since the last full backup.

Example SQL Backup Command (MySQL):

sqlCopyEditBACKUP DATABASE mydb TO DISK = 'C:\backup\mydb.bak';

Example SQL Restore Command:

sqlCopyEditRESTORE DATABASE mydb FROM DISK = 'C:\backup\mydb.bak';