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 |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2006-06-04 : 03:20:59
|
| Dear,I have backed up my database from server where we have hosted our website.After backing up database. I want to restore that database on my local computer's SQL SERVER.but it gives a msg as given below.First it gives "you are attempting to overwrite an existing database.check the force restore over existing database option to overwrite an existing database."When i check this option. it gives a msg as below.Device Activation Error.The Physical file name 'D:\home\resadmin\aswaqakhlj\aswaqalkhaleej.com\db\aswaq_data.mdf' may be incorrect.File 'aswaq_Data cannot be restored to 'D:\home\resadmin\aswaqakhlj\aswaqalkhaleej.com\db\aswaq_data.mdf'Use WITH MOVE to identify a valid location for the file.Device Activation Error.The Physical file name'D:\home\resadmin\aswaqakhlj\aswaqalkhaleej.com\db\aswaq_log.Ldf' may be incorrect.File 'aswaq_log cannot be restored to 'D:\home\resadmin\aswaqakhlj\aswaqalkhaleej.com\db\aswaq_LOG.Ldf'Use WITH MOVE to identify a valid location for the file.RESTORE DATABASE is terminating abnormally.the path('D:\home\resadmin\aswaqakhlj\aswaqalkhaleej.com\db\aswaq_data.mdf') is a server path not my local computer path.Please help me outWaiting for reply.regards, |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
problem in restoring database