When i try and restore thePhile DB in my SQL Server 2000 db I recieve the following error:

---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
Device activation error. The physical file name 'C:\Wrox\thephile_data.mdf' may be incorrect.
File 'ThePhile_Data' cannot be restored to 'C:\Wrox\thephile_data.mdf'. Use WITH MOVE to identify a valid location for the file.
Device activation error. The physical file name 'C:\Wrox\thephile_log.ldf' may be incorrect.
File 'ThePhile_Log' cannot be restored to 'C:\Wrox\thephile_log.ldf'. Use WITH MOVE to identify a valid location for the file.
RESTORE DATABASE is terminating abnormally.
---------------------------
OK
---------------------------

My SQL Server is not installed on c:\ but on my logical p:\. I have followed the instructions but i don't know why this error is occuring. Please help asap if anyone can.

Thanks
Garry

Why not try "with move" as it suggests?

restore database ThePhile
from disk = 'c:\thephile-database-backup'
with move 'ThePhile_Data' to 'p:\DB\thephile_data.mdf',
move 'ThePhile_Log' to 'p:\DB\thephile_log.ldf'

http://www.experts-exchange.com/Data..._20942138.html

Eric

Did this work?