Unable to remove MSSQL database from both Plesk and remote MSSQL server

Refers to:

  • Plesk 12.0 for Windows

Created:

2016-11-16 12:54:33 UTC

Modified:

2016-12-21 19:30:35 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to remove MSSQL database from both Plesk and remote MSSQL server

Symptoms

Unable to remove MSSQL database from both Plesk and remote MSSQL server after migration of subscription to Plesk 12.0.18.Source and destination Plesk are connected to the same remote MSSQL server.Database is removed only from Plesk.

Cause

This issue has been considered as software issue #PPPM-3431 and will be fixed in future product updates. Please use provided ID to track maintanance in Plesk release notes .

Workaround

First workaround

Database can be correctly removed under admin user:

    Plesk > Tools & Settings > Database Servers > click on the number of databases under Databases column > Remove

Second workaround

  1. Create backup of psa database:

    "%plesk_dir%\\mysql\\bin\\mysqldump" -uadmin -p"*******" -P8306 psa > C:\\psa.bk.sql
  2. Login to psa database:

    "%plesk_dir%\\mysql\\bin\\mysql" -uadmin -p"*******" -P8306 psa
  3. Find list of domains is that has disable_remote_db_remove parametr:

    select d.id,d.name,dp.param,dp.val from domains as d, dom_param as dp where d.id=dp.dom_id and dp.param='disable_remote_db_remove' group by id;
  4. Remove disable_remote_db_remove from dom_param table of psa database for all domains:

    delete from dom_param where param='disable_remote_db_remove';
Have more questions? Submit a request
Please sign in to leave a comment.