Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

restore from production to test

Status
Not open for further replies.

pengwyn

MIS
May 24, 2005
13
SE
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?



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top