Unable to create a copy or backup of MSSQL database

Created:

2017-02-02 12:21:09 UTC

Modified:

2017-08-08 13:42:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create a copy or backup of MSSQL database

Applicable to:

  • Plesk for Windows

Symptoms

  • Plesk is unable to create a copy or backup of a MSSQL database at Subscriptions > example.com > Databases > Copy . The following error is displayed in Plesk interface:

    Unable to clone database.
    
  • After the backup process, the following error is shown in the Backup Manager :

        Warning:domain "example.com" Unable to backup database content. Database example. Db server .\MSSQLSERVER2014:[Cannot open database "example" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\SYSTEM'.]
    

Cause

The database contains encrypted stored procedures, which are not supported by Plesk. It is a bug PPPM-5693 . It will be fixed in one of the future Plesk updates.

Resolution

As of now, the only solution is to not use encrypted procedures in the MSSQL databases.

Have more questions? Submit a request
Please sign in to leave a comment.