-
Written By
Phani Shrirangam -
Published on
March 12th, 2019 -
Updated on
September 4, 2023 -
Read Time
4 minutes
In this blog, I’ll explain how you can manually transfer a SQL Server Database from one server to another. If you’re concerned about losing data, don’t be, because the steps I’ll outline are safe and secure.
Also Read: 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.
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 the Provided SQL Server.
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 the Three Dots buttons to find the destination server location.
Use Windows Authentication– It allows the user to connect via Microsoft Account in Windows.
Use SQL Server Authentication permits the user to connect to SQL Server by entering username and password.
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
To sum it up, you should now be able to migrate a SQL database from one server to another with ease. I believe the information provided is sufficient. However, if by any chance you suspect the SQL database files are damaged, it’s a good idea to repair them using the SQL Repair Tool before moving them to another server. The choice is yours, so use your judgment wisely.
Related Post