• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

SQL DB restore fails

W

wsani

Guest
We upload the database backup file, then when a restore is attempted, the following error comes up in the Plesk log:

dbbackup.DbBackupException: Unable to restore database 'cheeky_db' ---> System.ApplicationException: Unable to open connection. Error code: 0x00000520
at psacommon.RemoteWinConnection.ConnectToNetworkResource(String host, String resourceName, ConnectionParameters connParams)
at psacommon.RemoteWinConnection.ConnectToNetworkResource(String host, ConnectionParameters connParams)
at dbbackup.DbBackupManager.Restore(String database, String backupPath, String netPath, String netUser, String netPass, Boolean dropLogins)
--- End of inner exception stack trace ---
at dbbackup.DbBackupManager.Restore(String database, String backupPath, String netPath, String netUser, String netPass, Boolean dropLogins)
at dbbackup.DbBackupManager.Main(String[] args)

Suggestions?
 
This was a permission issue. Plesk is unable to pass along the username/password that is required by the remote directory properly. So, I had to remove the user ACL and rely on network ACL to secure the "shared" restore directory.

This is after paying Parallels $75 for an incident... I finally fixed it myself...
 
Back
Top