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 |
|
mfemenel
Professor Frink
1421 Posts |
 Posted - 2001-10-12 : 08:25:08
|
| Trying to restore a backup file for database "Midsouth" to another server which does not have database "Midsouth"Just a regularRestore database Midsouthfrom disk='D:\ms\Midsouth_Backup'gives me the error that the file cannot be used with restore, consider using the with move option. Ok. So I use the "with move" option:Restore database Midsouthfrom disk='D:\ms\Midsouth_Backup'withMove 'Midsouth_Backup' to 'd:\ms\midsouth_data.mdf'Move 'midsouth_backup' to 'd:\ms\midsouth_data.ldf'and I get File 'Midsouth_Backup' is not a database file for database Midsouth. I'm totally hosed up here. Ideas Please? I'm sure i'm missing something very simple.Mike "Anyone think someone else is stupid, he/she is the stupid. " |
|
|
|
|
|
BACKUP HELP