Copy Database From One Server to Another Server in SQL

I have two servers, Server A and Server B.

Server A has database Test1 and I need to copy the same database to Server B.

Let us see step-by-step how to do it using the Configuration wizard.

  1. Open the SQL Server Management Studio and connect to Server A.

  2. Right-click on the database and select Tasks and then Copy Database.

    Copy Database

  3. Once you click on Copy Database then the following screen will appear.

    click on Copy Database

  4. Click on "Next".

  5. Enter the Source server name (for example, Server A) and enter the Server Authentication mode and click on "Next".

    Source Server

  6. Enter the Destination server name and authentication and click on "Next".

    Enter the destination server name

  7. Now use the SQL Management Object method and click on "Next".

    SQL Management Object

  8. Now under Select Databases you can see "Which databases would you like to move or copy"?. Let us select the Copy option and click on "Next". (If we select Move then the database will be moved to the next server).

    Now select the databas

  9. Now you can check the MDF and log file path on the destination machine.

    check the MDF

  10. If you have any job or procedure in the master database then select, else click on "Next".

    select else click on next

  11. Enter the log events if the copy fails. Here are two options: 1. System event view or 2. Local path. Now le us select the Windows event logs and click on "Next".

    Enter the log events

  12. Now select “Run immediately” if you want to run or schedule the run. Then click on "Next".

    Run immediately

  13. Now Verify the options and click on Finish.

    click on Finish

  14. Then you can see the progress of the status.

    progress of the status

  15. After Success close the windows and refresh the Server B database node. Now you can see Test DB is there with all the data.

    Test

I hope this will help in copying a database.