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 |
|
karnatik
Starting Member
5 Posts |
 Posted - 2005-05-04 : 10:22:34
|
| Hello Friends I got an SQL Server backup database. Now I have to open this database to analyze this database.I have installed SQL Server 2000 120 day trial version and tried to restore the database from Enterprise Manager.But am getting an error as follows."Device activation error. The physical file name 'D:\Dump\CIWIS_DP2_TEST.mdf' may be incorrect.File 'CIWIS_ORG_Data' cannot be restored to 'D:\Dump\CIWIS_DP2_TEST.mdf'. Use WITH MOVE to identify a valid location for the file. "So this is the error that I am getting if I try to restore the database. What does it mean? And please help me how can I solve my problem of restoring the database.Thank you in advance.Kiran. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-04 : 15:14:52
|
| Go to the second tab on the restore screen wizard. Change the path of the MDF and LDF to a directory that exists on this computer.Tara |
 |
|
|
karnatik
Starting Member
5 Posts |
Posted - 2005-05-09 : 02:15:30
|
| Thank you very much tduggan. that was a perfect solution for me. I have solved my probelm. no noi you have solved my problem .have a nice day.babaiii.Kiran. |
|
|
|
|
|
|
Now I have problem to restore the database