Want to save your progress?
Create a free account to track your lessons and quizzes across devices.
Register Login
« Back to ClassCompleted: 0%

Core DBA Tasks: Backup, Security, & Maintenance

Page 1 of 1

Backups: Strategies Across Engines

A DBA's number one job is ensuring data is never lost. The method changes based on the engine.

  • Logical Backups: These export the data as SQL commands (e.g., INSERT INTO...). They are portable but slower to restore.

    • MySQL: mysqldump
    • Postgres: pg_dump

  • Physical Backups: These copy the actual binary files from the disk. They are much faster for large databases.

    • SQLite: Copy the .sqlite file.
    • MySQL: Percona XtraBackup or copying the data directory (requires shutdown or locking).
    • MSSQL: Built-in Backup & Restore functionality in SSMS (creates .bak files).