Alert: Missing tables in RDS granular backups

Symptom

The RDS granular backup skipped a table and an alert was generated. 

Root Causes

The following limitations apply to RDS granular backups: 

  • For RDS for SQL Server and RDS for Oracle database tables, Clumio supports a maximum size of 1GB per row.
  • For RDS for SQL Server database names, the following characters are not supported: '?* | "{} and the character .. If an RDS instance contains database names with unsupported characters, the granular backup task skips these databases and generates an alert. All of the other databases are still backed up.
  • For RDS for SQL Server table names, only the following alphanumeric characters are supported: [a-zA-Z0-9]"_". If an RDS instance contains table names with unsupported characters, the granular backup task skips these tables and generates an alert. All of the other tables are still backed up.
  • For Aurora MySQL and Aurora Postgres, tables with the following characters in column names are skipped during export:,;{}()\n\t= and the character. If an RDS instance contains table names with unsupported characters, the granular backup task skips these tables and generates an alert. All of the other tables are still backed up.

Resolution

If you see 'tables skipped' alerts for your protected RDS assets, look for and update the tables that are impacted by the limitations listed above. You can see the skipped database/table file on the task details page in the UI as below.

rds.png

For any additional questions, reach out to [email protected]