All topics and tags

Backup

3 articles tagged Backup.

  1. Azure SQL Database Backups: Point-in-Time Restore, LTR and Geo-Restore

    Set PITR retention and backup redundancy, add a long-term retention policy, and run point-in-time, deleted-database, LTR and geo-restores for Azure SQL Database and Managed Instance.

    Databases & HA13 min read
  2. PostgreSQL Backups with pgBackRest: Full, Differential and PITR Restore

    Set up pgBackRest for PostgreSQL on Linux: WAL archiving, encrypted repositories, full and differential schedules, retention, an Azure Blob copy, and point-in-time recovery you have actually tested.

    Databases & HA12 min read
  3. SQL Server Error 9002 Transaction Log Full: Find the Cause and Fix It

    Fix SQL Server error 9002 by reading log_reuse_wait_desc, then resolving missing log backups, open transactions, Always On replica lag or a full disk, and size the log so it doesn't fill again.

    Databases & HA13 min read