Unable to Restore ndf to different drive letter
WindyCityGirl
Posts: 20
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!
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
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
Technical Support
Red Gate Software Ltd.