Symptoms

Plesk backups fails the error:

    Error: domain "domain.tld" 
    Unable to create dump 
    Error: domain "domain.tld" 
    Broken referencial integrity: DNS zone id 219 is not found in dns_zone

Cause

The record for domain is mising from psa.dns_zone table:

    # plesk db

    mysql> select * from dns_zone where id=219;
    Empty set (0.00 sec)

Resolution

1) Backup Plesk databases before any changes:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > ~/psa_`date +%F_%H.%M`.sql

2) Access to Plesk database and add dns_zone for domain in dns_zone table:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa

    mysql> INSERT INTO `dns_zone` VALUES (219,'domain.tld','domain.tld',0,'true','true','test@domain.tld','master',86400,86400,10800,3600,3600,3600,604800,86400,10800,3600,'UNIXTIMESTAMP','1389108685')
    Query OK, 1 row affected (0.30 sec)