• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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