Check app-settings

Your own SQL, run read-only against the restored copy (never production), with a statement timeout. The SQL is stored verbatim in every report.

Check

Referential spot-check

No child row points at a parent row that does not exist.

Child table

Its column

Parent table

Its key column

Name

Database (optional) Empty: the first restored database.

SQL One read-only statement; for MongoDB one mongosh expression, e.g. db.orders.countDocuments({status: "paid"}). The first 100 rows are kept as evidence.

Expect

Value

Timeout

When it does not match

between: the value is from … to, both included; regex: a pattern the value must match; not_null: any value that is not NULL; rows>=: the query returns at least this many rows. Timeout: 60s unless set (e.g. 2m).

Restores the newest backup first: about 9m 11s.

Delete this check

Delete app-settings. Past reports keep its results.