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 |
|
SQLError
Yak Posting Veteran
63 Posts |
 Posted - 2004-09-18 : 22:18:33
|
| Hi, I was reading up on transaction logs and from what I gatherto restore your db, you restore the last full backup and thenrestore the transaction logs from earliest to latest.What if the first log you try to restore will not restore?does that mean you can not restore any other?thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-19 : 01:30:37
|
| YupNote that it is a good idea to do Transaction backup just before the Full backup - otherwise the first transaction log backup AFTER the full backup may contain huge amounts of stuff from before the Full backup,. as well as the stuff from after it, and so during a restore SQL will have to wade through all the stuff that was already in the Full Backup, which wastes time.Enterprise Manager is pretty good at Restore. It will list all the Full, Differential and Transaction logs with an easy Tick-and-go means of choosing what you want to restore.KristenKristen |
 |
|
|
|
|
|
Restoring from transaction logs