| Migrating/Moving database(s) across SQL Servers |
|
|
|
|
Following are the steps to be followed before migrating/moving a database
1) Take a backup of the source database and save it in a shared folder in the corresponding source server.
2) Copy the backup file from the share folder of the source server into the destination server.
3) Take a backup of the users in the source database. How to transfer logins & passwords for a particular database is shown in the below link
4) Once the scripting of the users in the source database is over restore the source database into the destination server.
5) Once the restoration is complete apply the login script that has been generated in the step 3.
6) This step would ensure that all the original logins are maintained in the destination database even after restoration.
Comments (31)
Powered by !JoomlaComment 4.0 beta2
|


