SQL Server Performance

How to Backup database to another machine

Discussion in 'General Developer Questions' started by rudianto, Aug 5, 2008.

  1. rudianto New Member

    Dear all,
    I have database that's running on server A, i was backup it to local server folder its successfully, then i copy this backup database file (.bak)
    to my local PC and restore it to mysqlserver local but i've get this error
    "Device activation error the phyisical file name : 'd:programfile......" may be incorrect"
    on end message its "Use WITH MOVE to identify a valid location for the file. RESTORE DATABASE is terminating abnormally"
    please help me... how to solved this problem
  2. satya Moderator

  3. Bob L New Member

    When you attempt to restore the database, the drives (path) that the original data files were using are apparently not available on your machine. When you restore the file, either use the MOVE option of the RESTORE command if doing it manually, or by going to the appropriate screen (Options screen) in Management Studio if doing it from the GUI, and changing the file paths of the data and log files being restored.
    It wants to put them in the original paths, and your machine isn't set up that way.
    Hope this helps.

Share This Page