Move a database from one cloud server to another cloud server and/or host.
You must have the MoveDatabase privilege.
To move the primary database, both the primary and the mirror databases must be running.
To move the mirror database, the primary database must be running.
To move all the databases from a cloud server, use load balancing.
Connections to the database can be dropped or temporarily disabled.
|Move a primary database in a mirroring system||Click.|
|Move a mirror database in a mirroring system||Click.|
|Move a database that is the read-write copy in a read-only scale-out system||You cannot move the read-write database in a read-only scale-out system.|
|Move a read-only scale-out database copy||
Move a database that is not part of a mirroring or read-only scale-out system
If the original database was running or if the original database was stopped, then the database or database copy is moved to the specified cloud server.
If you moved a stopped database, the database is not started on the new cloud server. You must restart it manually.