We have four different environments: DEVINT, TEST, STAGE, and PROD, each on their own Azure SQL Database server.  I can copy a database between any two of these, using the command CREATE DATABASE mine AS COPY OF <server>.mine, *EXCEPT* that I cannot copy to/from the PROD instance.  Since what we need to do is to copy from PROD to one of the others to do non-production refresh, I'm stuck.

Any ideas out there?  All have the same sysadmin account name, with the same password.

Hello,

Did you received any error message when copy database from or to the PROD server?

A SQL Database subregion might consist of multiple physical clusters. Currently, we cannot copy a database between two different clusters.

Before you copy database, please determine whether copying a database is possible:  Use a ping command ("ping <server>") on both the source and destination servers to resolve their IP addresses. If the IP addresses are equal, the database copy is possible. Otherwise, you should migrate the database to a server in the same subregion and then preform a database copy.

Reference:Copy Your Databases (Windows Azure SQL Database)

Regards,
Fanny Liu

If you have any feedback on our support, please click here. 

The message I'm getting is:

    Msg 40532, Level 11, State 1, Line 2

    Cannot open server "omlk8awtps" requested by the login.  The login failed.

When I PING the servers, they're all in the same address except PROD: 

DEVINT: 168.62.32.172

TEST: 168.62.32.172

STAGE: 168.62.32.172

PROD: 168.62.32.75

How do I migrate to the same subregion?  All of them are in EAST US, and I don't see any way of any more granular specification.  

See here: http://sqltuna.blogspot.co.uk/2013/11/can-i-copy-database-can-i.html

It explains some quirks of the COPY command.  The chances are it's related to the login sid.

See here: http://sqltuna.blogspot.co.uk/2013/11/can-i-copy-database-can-i.html

It explains some quirks of the COPY command.  The chances are it's related to the login sid.

• Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator 4 hours 29 minutes ago

See here: http://sqltuna.blogspot.co.uk/2013/11/can-i-copy-database-can-i.html

It explains some quirks of the COPY command.  The chances are it's related to the login sid.

• Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator Thursday, May 01, 2014 6:03 AM

See here: http://sqltuna.blogspot.co.uk/2013/11/can-i-copy-database-can-i.html

It explains some quirks of the COPY command.  The chances are it's related to the login sid.

• Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator Thursday, May 01, 2014 6:03 AM

See here: http://sqltuna.blogspot.co.uk/2013/11/can-i-copy-database-can-i.html

It explains some quirks of the COPY command.  The chances are it's related to the login sid.

• Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator Thursday, May 01, 2014 6:03 AM

See here: http://sqltuna.blogspot.co.uk/2013/11/can-i-copy-database-can-i.html

It explains some quirks of the COPY command.  The chances are it's related to the login sid.

• Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator Thursday, May 01, 2014 6:03 AM

See here: http://sqltuna.blogspot.co.uk/2013/11/can-i-copy-database-can-i.html

It explains some quirks of the COPY command.  The chances are it's related to the login sid.

• Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator Thursday, May 01, 2014 6:03 AM