Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cirugio
Yak Posting Veteran
90 Posts |
 Posted - 2010-05-22 : 14:28:39
|
| I have a backup of a sql database which I would like to restore to another pc. The backup was performed on a sql server 2000 machine which contained an c:, d:, e:, and F: drive. I am trying to restore this to on another pc which houses an sql 2000 evaluation copy of sql. This other pc only has a c:\ drive in which I am trying to restore the backup database from an external drive (F:). In trying to do so, I am getting the following error (see below). I am not exactly certain how to go about restoring this database. It notes to use WITH MOVE, but I don't know exactly how to doe this. Any help or guidance is greatly appreciated. Thanks in advance.ERROR Message:Microsoft SQL DMO (odbc sql state: 42000)Device activation error. The physical file name 'e:\MSSQL7\Data\QRM_TEST_DATA.MDF' may be incorrect. File 'QRM_TDM_DMT_Trade Repository_Securities_DATA' cannot be restored to e:\MSSQL7\Data\QRM_TEST_DATA.MDF.Use WITH MOVE to identify a valid location for the file.Device activation error. The physical file name 'l:\MSSQL7\Log\QRM_TDM_DATA.ldf' may be incorrect.File 'QRM_TDM_DMT_Trade Repository_Securities_LOG' cannot be restored to 'l:\MSSQL7\log\QRM_TEST_DATA.idf'. Use WITH MOVE to identify a valid location for the file.RESTORE DATABASE is terminating abnormally. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-22 : 16:15:24
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300 may help |
 |
|
|
cirugio
Yak Posting Veteran
90 Posts |
Posted - 2010-05-22 : 22:20:03
|
| Thanks Kristen. I will give this a try. |
|
|
|
|
|
|
Restoring a bkup to a different pc - WITH MOVE