What are the challenges you face when working across database platforms? Take the survey
Options

Unable to Restore ndf to different drive letter

WindyCityGirlWindyCityGirl Posts: 20
edited December 3, 2015 6:32PM in SQL Backup Previous Versions
Hello,

I have 1 Server with two SQL Server Instances installed. I am trying to restore the same SQL backup to each instance. The backup comes from a different server (production). The database has multiple ndf files. The drive letter/structure on the sever I am restoring to matches the production server and has two additional drives.

The restore to the first instance works perfectly, it is using the same drive letters and folder structure as the Production server does for the ndf files. Drive F: Data Files Drive G: Log Files

The restore to the second instance fails. The restore job is identical to the first with the following exception Drive J: Data Files Drive K: Log File - remaining folder structure is a match.

Activity Log

Display value too large: 9790
12/2/2015 4:25:32 PM: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
12/2/2015 4:25:32 PM:
12/2/2015 4:25:32 PM: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
12/2/2015 4:25:32 PM:
12/2/2015 4:25:32 PM: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
12/2/2015 4:25:32 PM: SQL error 3119: SQL error 3119: Problems were identified while planning for the RESTORE statement. Previous messages provide details.
12/2/2015 4:25:32 PM: SQL error 3156: SQL error 3156: File 'File201612C02Trade' cannot be restored to 'F:DataESN_DATA_Bilateral20162016C02Trade201612C02Trade.ndf'. Use WITH MOVE to identify a valid location for the file.


I am using a WITH MOVE in the job

, MOVE 'File201501C01Trade' TO 'J:DataESN_DATA_Bilateral20152015C01Trade201501C01Trade.ndf'

I also tried

, WITH MOVE 'File201501C01Trade' TO 'J:DataESN_DATA_Bilateral20152015C01Trade201501C01Trade.ndf'

What am I doing wrong?

Thank you for your help!

Comments

  • Options
    Hi
    Thanks for your inquiry, and sorry to hear about your issue.
    As this situation will require some additional troubleshooting, we have opened a ticket for you, and will communicate with you from this ticket.

    Thanks!

    Rick
    Ricky Ram
    Technical Support
    Red Gate Software Ltd.
Sign In or Register to comment.