• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

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