While creating a new domain/subdomain/alias for a domain on the Plesk panel getting following error:

```
This DNS record already exists
```

To fix this issue, follow the below steps:

1) Connect to the Plesk Windows server via RDP.

2) Take a database dump of the Plesk database using the following command under the command prompt(Start CMD as an Administrator).

plesk db dump psa > C:\psa_24x7_backup.sql

Click image for larger version

Name:	DNS_1.png
Views:	1
Size:	37.6 KB
ID:	868

3) Access the Plesk database using the following command in CMD:

plesk db

Click image for larger version  Name:	DNS_2.png Views:	1 Size:	39.3 KB ID:	863


4) Find dns_zone_id of the domain, which cannot be created, using the following command.

select dns_zone_id,host from dns_recs where host like "%aicp.ir%";

Click image for larger version  Name:	DNS_3.png Views:	1 Size:	18.3 KB ID:	864


Replace aicp.ir with your actual domain name:

5) Using dns_zone_id from the output above, make sure that the domain name is the same:

select id,name from dns_zone where id=628;

Click image for larger version  Name:	DNS_4.png Views:	1 Size:	6.2 KB ID:	865


6) Delete records from corresponding tables using the ID from the steps above

delete from dns_zone where id=628;
delete from dns_recs where dns_zone_id=628;

Click image for larger version  Name:	DNS_5.png Views:	1 Size:	8.2 KB ID:	866


Now, you will able to create the domain/subdomain/alias in Plesk without any issue.