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 |
|
brian_ma
Starting Member
1 Post |
 Posted - 2008-04-02 : 02:45:31
|
| Dear all,I meet a problem on restore database to SQL serverERP System: SAP R/3OS: MS Windows2003 EnterpriseSQL Server: Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)Symptom:When I restored the database from a bak file, an error message appeared:Title = Microsoft SQL-DMO (ODBC SQLState: 42000)Content = Device active error. The physical file name 'f:\PRDDATA1\PRDDATA1.mdf' may be incorrect.Detail Description:1. I have checked the SQL server version, the version of "the database was restored to" and "the database was backup from" are same.2. I have tried to setup the SAP R/3 to another server, and restored the backup to it. It works. But when I restored the database to this already restored database again. This error message appeared again.Remark: The backup file does NOT corrupt; And both version of database restore to and backup from are same.How to solve my problem?Regards,Brian |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-02 : 03:16:29
|
| Does the folder exist?Do you need to use the move option with the restore?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-02 : 14:58:16
|
| Can you post your restore script?Terry |
|
|
|
|
|
|
problem on restore database to SQL server