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 |
|
ismaelhaider
Starting Member
2 Posts |
 Posted - 2008-09-10 : 01:53:05
|
| I have backup the full backup and then log backup, but can i only restore the database using log backup, |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-09-10 : 03:54:49
|
| No. All the log backup has in it is the transactions that occurred between the previous log backup and that one.Restore the full backup first, with norecovery, then try to restore the log backup. Providing it is the log backup that correctly follows the full (ie, no missing transactions), you'll be able to restore it.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Can i restore database only using log file