How to migrate database in SQL server from one server to another?

Home Forums How to migrate database in SQL server from one server to another?

This topic contains 2 replies, has 3 voices, and was last updated by  Natalie Chopra 2 months, 3 weeks ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #7263 Score: 0

    Justin Hansen
    Participant

    Hello everyone currently I am using SQL Server 2008 and I want to migrate database from server 2008 to server 2012. But I am not able to do that so please help me.

    #7266 Score: 0

    Eddie Thwan
    Moderator
    44 pts

    Hi There are many methods available to migrate your data from one server to another server. One is Backup and restore method;
    Step1- Take the backup from the source database so that it can occupy later on the destination path such as on server 2005.
    Step2- Now connect the instance of SQL Server to the destination computer (on which you want to copy the database). And if needed create the same backup devices on the destination server.
    Step3- Now restore the backup on the destination server of the source database. Basically restoring the database makes all database files.

    #7267 Score: 0

    Natalie Chopra
    Moderator

    Here it is manual method follow the following steps-
    Step1- First of all launch the Sql Server Management Studio from object explorer and connect to the source server.

    Step2- Now click right on database then select option task and then copy database.

    Step3- Then it opens a screen click next on it.

    Step 4- Fill the information asked then click on next.

    Step 5- Now fill destination server name then click next.
    Step6- You can use the SQL management object method and then press next.

    Step 7- By this you can verify MDF and Log files also. And if you have any procedure inside the master database then select, further click next button.

    Step 8-Now select Windows event log after then click next option.

    Step 9- If you want to run it Run then press next.

    Step10- In last you have to check the option and then press on finish option.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.