Post reply

Moving Servers

  • June 28, 2005 at 8:37 am

    #109984

    Hi

    I am a novice. I am moving my site to a new server. I backed up my MSDE database but I can't seem to FTP or download the backup to the new server.

    How can I get the backup from one server to the other. Im hoping it is easy, Im not a programer.

    Thanks

  • June 28, 2005 at 8:59 am

    #568959

    does the 2 computers connected ?

    if not you have to move the backup file .

    can you bring more details?

  • June 28, 2005 at 9:06 am

    #568963

    No, the servers aren't connected. They are two seperate internet servers but in the same data center.

    Could it be done by remote access? If not how could I move it. Do you need any more details?

    Thanks for your help.

     

  • June 28, 2005 at 1:02 pm

    #569104

    You have to have these servers connected or you should find any way to move those backup files to the destination server. Once its done restore those databases using EM or T-SQL thats it.

     

     

     

    With Smiles

    Santhose

  • June 29, 2005 at 8:57 am

    #569357

    If you can connect to both machines. copy the backup to your workstation, then copy it again to the destination server

    Francis

  • June 29, 2005 at 8:42 pm

    #569661

    Francis

    Thank you. I can copy and paste in the workstation but I can't copy and paste it from one server to the other.

    Could you explain how to copy the backup if not by copying and pasting?

    Thanks

  • June 30, 2005 at 10:54 am

    #569992

    Can you access, the internet?

    If the backup isnt that big try sending it by email? If this is not an option which I presume it isnt try this...

    Did you say they were on the same domain? If so, share the folder with the files on them and then access the machine using the run command,

    //server_name/shared_folder

     

    If not,

    Copy the backup file to your machine and then when it copied to your machine copy it to the destination machine,

    Regards,

    M

     

     

     

     

  • June 30, 2005 at 11:47 am

    #570031

    Thank you. I never thought about emailing it. That did the trick.

  • June 30, 2005 at 1:43 pm

    #570113

    OK I have the backup on the right server. I stored it in the backup folder in the SQL folder of the Program Files.

    When I go to Enterprise Manager and right click on the database and try to restore it I don't get the option to select the backup file.

    Am I missing something?

    Thanks

     

Viewing 9 posts - 1 through 8 (of 8 total)

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