SQL Error
-
I was restoring a database when I encountered this error.. It says.. "Device activation error. The physical file name 'C:\mydatabase\SQL_LIVE\mydata.mdf' may be incorrect. File 'mydata_Data' cannot be restored to c:\mydatabase\SQL_Live\mydata.mdf'.Use WITH MOVE to identify a valid location for the file. RESTORE DATABASE is terminating abnormally." What does this mean? I was restoring the database to my workstation and the database came from our server.. because our server was infected with virus.. Does the virus have anything to do with my error? Can anybody help me with my problem? Please reply ASAP.. TNx!
-
Assuming that you are using Enterprise Manager ...
When you perform the restore, the default paths for the restored files (database and transaction log) will be the same as they were on the server. So if your PC does not already have the path
c:\mydatabase\SQL_Live
you will probably get this error.
To fix it, when you are completing the Restore Database dialog, click on the Options tab and manually amend the file path in the 'Move to physical file name' section to point to the correct location/file for your PC.
Regards
Phil
-
Tnx! its now working...
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply