Unable to migrate databases: Failed to copy content of database: Unable to copy database

Created:

2016-11-16 12:45:18 UTC

Modified:

2017-08-08 13:19:13 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to migrate databases: Failed to copy content of database: Unable to copy database

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

Migration fails with the following error:

      `- error: Failed to copy content of database 'database name'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.
command: cmd.exe /C ""C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\dbbackup.exe" --copy -copy-if-logins-exist -with-data -src-server="mssql.example.com" -server-type="mssql" -src-server-login="sa" -src-server-pwd="********" -src-database="database_name" -dst-server="MSSQLDEST" -dst-server-login="sa" -dst-server-pwd="*hidden*" -dst-database="database_name""
exit code: 23
stdout: Unable to copy database 'database_name' to database 'database_name''

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

The network path was not found

Cause

A network-related issue with connection to a database server.

Resolution

  1. Try to disable the firewall on a source server. This article posted by Microsoft can be used.

  2. Make sure that connection to the database could be established from the target server. The connection can be tested using the following command on the target server:

    "%plesk_bin%\mssqlmng.exe" --check "--server=203.0.113.2" "--login=user" "--password=password"
Note: in order to test a connection between a source and a target database server SQL Management Studio also can be used.
Have more questions? Submit a request
Please sign in to leave a comment.