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 |
|
Zoroaster
Aged Yak Warrior
702 Posts |
 Posted - 2007-08-20 : 12:34:12
|
| I have a theoretical question, let's say that you have a DB with a weekly full backup and hourly transaction logging. If for some reason the datafile is lost requiring a restore of the database, AND the full backup is corrupted, is it possible to do a restore using the transaction logs only? I manually replicated the scenario but couldn't find anyway of restoring the DB using just the transaction logs without the full backup, though in theory (I thought) it should be possible, right? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-20 : 13:00:37
|
| nope |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-08-20 : 13:05:42
|
| Thanks |
|
|
|
|
|
|
Question about restore