Post reply

Moving Database from one server to other, and rename it

  • July 21, 2008 at 3:57 pm

    #210248

    Hi all,

    I perform the following to move one databse from one server to other one by using SSMS:

    1) offline DB

    2) detach DB

    3) copy/paste all mydb.mdf, and mydb.ldf files

    4) attach DB

    5) in the database/rename properties....change name,......click ok.

    Are they ok?...do I have to do something else?????

    Please I need some help...I have to move one PROD DB and I feel confusing with this.....do I have to move master,msdb, model..files????

    Please help..

    Thanks

  • July 22, 2008 at 1:48 am

    #846199

    You can also create a backup of the current database and restore this backup on the new server and with the new database name. The advantage is that you can keep the other database online.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • July 22, 2008 at 4:51 am

    #846274

    back-up and restoring with different name is the solution. But do keep in mind that teh physical names are not changed when you specify the name of the database while restioring. You have to change the physical names of the files manually in the Options page.

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

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

You must be logged in to reply to this topic. Login to reply