How to copy a MS SQL Database in Plesk
To make a copy of database, perform the following steps:
1 – Logged in to Plesk.
2 – Go to Databases.
3 – Click Copy under the database name you want to copy.
4 – Select Destination database server.
• For a remote server, select Other.
• Enter Host name or IP address of the remote database server.
• Enter Username and password of the remote database server’s administrator.
5 – Checkbox selected Create a full copy, to create a full database copy including data in the tables