I am attempting to restore a database on a different server via QA from a full backup. The syntax I'm using is as follows:
RESTORE DATABASE TEST_SQL
FROM DISK = '\\SQL\PROD\Prod_db_200710230300.BAK'
WITH MOVE 'Prod_Data' TO 'E:\Program Files\Microsoft SQL Server\MSSQL\Data\Prod_Data.MDF'
, MOVE 'Prod_Log' TO 'E:\Program Files\Microsoft SQL Server\MSSQL\Data\Prod_Log.LDF'
I am getting the following errors:
Server: Msg 5105, Level 16, State 2, Line 4
Device activation error. The physical file name 'F:\MSSQL\Data\Prod_Data.MDF' may be incorrect.
A similar error pops for the log file. The paths in the error are those of the physical files for the Prod database on other server.
I double-checked all paths and they are correct. Could this be a network permissions issue? Does the restore process somehow validate the physical file paths of existing database before it restores to a different server?
Thanks in advance.