How to Copy SQL Server Database from One Server to Another?

  •   Written By
     
  • Published on
    March 12th, 2019
  • Updated on
    December 2, 2022
  • Read Time
    4 minutes
5/5 - (1 vote)
Summary:-Sometimes it becomes hard for the user to copy SQL Server Database from one server to another manually. The chances of corruption and data loss are high. But if I tell you that there is a way out through which you can copy SQL Data from one server to another then I think it would be helpful for you. but if there is any problem with the SQL Server then you will have to use the SQL Database Recovery Tool and then start migrating SQL Database from one to another.

Why don’t you try to migrate the SQL database manually?

So in this blog, I am going to tell you how you can copy SQL Server Database from one Server to another manually. If you have the fear of data loss then don’t worry about it because the steps which I am going to tell you would be safe and secure.

Read here: Backup And Restore SQL Database by Recovery & NoRecovery in MS SQL Server

Well, let’s move on to the steps to copy SQL Database from one server to another.

  • Launch SQL Server Database and connect it to the Source Server.
  • Click on Task. Point the cursor on Task and Select Copy Database.
migrate sql database
  • A Wizard will appear in front of you. Click on Next to Continue.
sql server migration
  • Type or Browse the Source server from where you have to migrate the SQL Database. Click on Next for creating the connection.

You are just following the steps but do you know what the above terms mean? You must also know what actually these terms mean.

Source Server– It is used to identify the server name where you want to copy the SQL Database. Either you can type the path or just browse the location by clicking on the Three Dots button. The version of your SQL Server must be 2005 and beyond.

Use Window Authentication– In this, the user can connect with the SQL server by entering an ID and Password.

Use SQL Server Authentication- This allows the user to connect with Provided SQL Server.

  1. Username- You have to enter a username in order to connect to SQL Database.
  2. Password- A security key which has to be entered in order to make access to the SQL Server.
  • Now choose the Destination Server where you want to move SQL Database. Then Click on Next.
migrate sql database from one to another

Well, I am quite sure that here also you are eager to know the terms. Let me explain:-

Destination Server– It is the server where you want to move the SQL Data. Similarly, as you have browsed the Source Server, here also you have to follow the same procedure. Click on Three Dotsbuttons to find the destination server location.

Use Windows Authentication– It allows the user to connect via Microsoft Account in windows.

Use SQL Server Authentication-It permits the user to connect to SQL Server by entering username and password.

  • Select Use the SQL Management Object method Option and Click on Next move further.
sql server migration
  • Step 7- Now you can see the Selected Database which you want to migrate. Select the Copy option and Click on Next.
  • Here you can verify the MDF file and Log File Path on the system. Click on Next to Continue.
migrate sql server database
  • Read and confirm the information here and click on Next.
migrate sql server
  • Enter all the log events and click on Copy.
  • Select the Windows Event log and Click on Next.
sql server database migration
  • Choose the Run Immediately Option and Click on Next.
sql server migration
  • Just go through once from all the options and click on Finish.
sql server
  • Here you can view the Progress Report. Finally you succeed in migrating SQL Database from one server to another.
sql database
  • You can view the Database file on another server where you have saved it.
sql server migration

Well, these steps are quite lengthy but I assure you that they are effective too. You can migrate the SQL database from one server to another without losing any data. These are the manual steps to perform such an activity.

Conclusion

Now it is time to wrap up things and I am pretty sure that you can copy SQL database from one server to another easily. I hope all the information is enough for you. But if in the rarest chances you feel like the SQL database files are corrupted and you want to migrate it then I would suggest repairing them first by SQL Repair Tool and then moving them to another server. It is up to you to be smart and take your decision accordingly.

Related Post