I am trying to restore a database from a file on a remote machine. The script I am using is as follows:
RESTORE FILELISTONLY FROM disk = '\\server\path\to\file.dmp' RESTORE DATABASE MyDB FROM disk = '\\server\path\to\file.dmp' WITH REPLACE, MOVE 'MyDB_Data' TO 'D:\path\to\file.mdf', MOVE 'MyDB_Log' TO 'D:\path\to\log.ldf', stats = 20 GO
I am using this script because the SQL Server Management wizard appear to dislike the use of a .dmp file instead of a .bak file, though my team has used .dmp files in the past without issue. However, whilst the RESTORE FILELISTONLY command appears to complete successfully, the RESTORE DATABASE command fails with the following error.
Msg 3203, Level 16, State 1, Line 3 Read on "\\server\path\to\file.dmp" failed: 38(failed to retrieve text for this error. Reason: 15105) Msg 3013, Level 16, State 1, Line 3 RESTORE DATABASE is terminating abnormally.
This seems unusual, as it appears to be an error with the .dmp file, but the previous RESTORE command did not complain at all. On top of this, the database in question is now stuck in a neverending "Restoring..." state which I cannot seem to get it out of. I tried
RESTORE DATABASE MyDB WITH RECOVERY but that gave the same error, tried adding
RECOVERY to the original script but just got the same error.
Any idea what's going on? I am new to DBA, myself, so I have limited experience to draw upon.