|
Subject:
|
Installing thePhile Database help
|
|
Posted By:
|
glabana
|
Post Date:
|
7/22/2004 8:04:08 AM
|
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
|
|
Reply By:
|
englere
|
Reply Date:
|
7/22/2004 9:09:52 PM
|
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/Databases/Microsoft_SQL_Server/Q_20942138.html
Eric
|
|
Reply By:
|
Malnad
|
Reply Date:
|
1/11/2006 11:19:53 AM
|
Did this work?
|
