Applicable to:
- Plesk for Windows
Symptoms
-
Copying a MSSQL database in Domains > example.com > Databases > example_db > Copy fails:
PLESK_ERROR: Unable to clone database.
The following error is logged into the file
%plesk_dir%admin\logs\php_error.log:CONFIG_TEXT: ERR [panel] Task failed: id=1615, pid=25416, type=db-clone, error=dbbackup failed: Unable to copy database 'example_db' to database 'example_db_clone''
Script transfer failed.
Script failed for Server '.\MSSQLSERVER2014'.
Property TextHeader is not available for StoredProcedure '[dbo].[stored_procedure_name]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.
(Error code 23) -
After the backup process, the following error is shown in Tools & Settings > Backup Manager :
CONFIG_TEXT: Warning:domain "example.com" Unable to backup database content. Database example_db. Db server .\MSSQLSERVER2014:[Cannot open database "example_db" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\SYSTEM'.]
Cause
The database contains encrypted procedures, which are not supported by Plesk.
This has been reported as bug ID PPPM-5693.
Resolution
Currently, the only solution is to avoid using encrypted procedures in the MSSQL databases.
Comments
4 comments
It won't work even without encypted SPs
@Marco Marsala
What the error do you have? is it still the same
And am I right, that the database is not encrypted and you can login to this database by clicking "MyLittleAdmin" button near the database?
It isn't that error, it says only "Database cloning failed". I can login via myLittleAdmin. The DB is not encrypted.
@Marco I believe this article is not the one describing the issue you faced. I can see your comment in the article below:
https://support.plesk.com/hc/en-us/articles/115001313633-Copy-database-not-working-no-errors-are-shown-in-Plesk-GUI
I believe that article is describing your case.
Please sign in to leave a comment.