Post reply

copying a database from one server instance to another server instance

  • September 5, 2017 at 8:13 am

    #1958107

    Sue_H - Tuesday, September 5, 2017 7:55 AM

    briancampbellmcad - Tuesday, September 5, 2017 7:49 AM

    OK Ran the below with a new set of errors:

    RESTORE DATABASE ACS_DB
    FROM DISK = 'C:\DATABASES\ACS_DB_backup_201709010016.bak'
    WITH
    MOVE 'ACS_DB_Data' TO 'D:\Databases\Data\ACS_DB_Data.MDF',
    MOVE 'ACS_DB_LOG' TO 'D:\Databases\Data\ACS_DB_Log.LDF',
    REPLACE
    ;


    Msg 5133, Level 16, State 1, Line 3
    Directory lookup for the file "D:\Databases\Data\ACS_DB_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.).
    Msg 3156, Level 16, State 3, Line 3
    File 'ACS_DB_Data' cannot be restored to 'D:\Databases\Data\ACS_DB_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
    Msg 5133, Level 16, State 1, Line 3
    Directory lookup for the file "D:\Databases\Data\ACS_DB_Log.LDF" failed with the operating system error 3(The system cannot find the path specified.).
    Msg 3156, Level 16, State 3, Line 3
    File 'ACS_DB_Log' cannot be restored to 'D:\Databases\Data\ACS_DB_Log.LDF'. Use WITH MOVE to identify a valid location for the file.
    Msg 3119, Level 16, State 1, Line 3
    Problems were identified while planning for the RESTORE statement. Previous messages provide details.
    Msg 3013, Level 16, State 1, Line 3
    RESTORE DATABASE is terminating abnormally.

    The path you use for moving the files to on the restore must exist. The errors "Use WITH MOVE to identify a valid location for the file" and "The system cannot find the path specified" indicate that the path:
    D:\Databases\Data\
    does not exist.

    Sue

    Thanks Sue! it finally worked I made sure I had this in place "This PC > Data (D:) > Databases > Data" and that was indeed the issue.

  • September 5, 2017 at 8:15 am

    #1958108

    briancampbellmcad - Tuesday, September 5, 2017 8:13 AM

    Thanks Sue! it finally worked I made sure I had this in place "This PC > Data (D:) > Databases > Data" and that was indeed the issue.

    Note that Anthony Green did ask this question in the very first response to your original post. I'm surprised that you did not take note at that point.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 16 through 16 (of 16 total)

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