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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2004-02-10 : 18:58:22
|
| Hi, Is it possible to restore/create a database (with one data and one log file) from a backup which contains one data BUT two log files?Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-10 : 20:44:20
|
| Not initially. You have to restore all three files but you can move them to any location you like. Once it's restored you can ALTER DATABASE and drop the log file you don't need. |
 |
|
|
|
|
|
Restore database with two log files