I get the error message:
Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'x:\x\x.mdf' may be incorrect.
The correct path is there on the test server and the files from the test db are there to be overwritten.
I have also tried to create a new database with the restore from production an still get the same error when there are no files there to begin with.
I have tried running the script
RESTORE DATABASE tmpDispDocs
FROM DISK = '\\UKCGBSS01\backups$\Production\DispDocs\DispDocs.bak'
WITH MOVE 'DD03_Data' TO 'D:\SQL Server2000\MSSQL\Data\tmpDispDocs.mdf',
MOVE 'DD03_Log' TO 'D:\SQL Server2000\MSSQL\Data\tmpDispDocs_log.LDF'
when creating a new database
and
RESTORE DATABASE DispDocs
FROM DISK = '\\UKCGBSS01\backups$\Production\DispDocs\DispDocs.bak'
WITH MOVE 'DD03_Data' TO 'D:\SQL Server2000\MSSQL\Data\DispDocs.mdf',
MOVE 'DD03_Log' TO 'D:\SQL Server2000\MSSQL\Data\DispDocs_log.LDF'
to replace the test database.
I have tried to use the force option on the Enterprise Manager restore tab but that does not help.
What is going wrong?
Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'x:\x\x.mdf' may be incorrect.
The correct path is there on the test server and the files from the test db are there to be overwritten.
I have also tried to create a new database with the restore from production an still get the same error when there are no files there to begin with.
I have tried running the script
RESTORE DATABASE tmpDispDocs
FROM DISK = '\\UKCGBSS01\backups$\Production\DispDocs\DispDocs.bak'
WITH MOVE 'DD03_Data' TO 'D:\SQL Server2000\MSSQL\Data\tmpDispDocs.mdf',
MOVE 'DD03_Log' TO 'D:\SQL Server2000\MSSQL\Data\tmpDispDocs_log.LDF'
when creating a new database
and
RESTORE DATABASE DispDocs
FROM DISK = '\\UKCGBSS01\backups$\Production\DispDocs\DispDocs.bak'
WITH MOVE 'DD03_Data' TO 'D:\SQL Server2000\MSSQL\Data\DispDocs.mdf',
MOVE 'DD03_Log' TO 'D:\SQL Server2000\MSSQL\Data\DispDocs_log.LDF'
to replace the test database.
I have tried to use the force option on the Enterprise Manager restore tab but that does not help.
What is going wrong?