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 |
|
learntsql
524 Posts |
 Posted - 2010-03-24 : 08:13:27
|
| HI All,Following is my backup stratagy for my TestDB database(FULL Recovery Model) which has EMP tableFull-->Diff-->TLogFull backup with initial two recordsDiff backup with two more recordsTLOG backup with 2 more recordsBut in my restore process first i restored Full backup and then TLOG.When i open Emp table in my restored database EMP table contains all the records(2+2+2).How come its possible?plz. explain me.TIA |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 13:04:17
|
TLog backup is ALL transactions since the previous Tlog backup (which was presumably either Before the FULL backup OR there were no backups before the Full backup - so that Tlog backup is the "first ever Tlog backup" - special case  )TLog backups has no relationship with Full / Differential backup.You could make Full Backup (1)Then make no new Tlog backups but make (say) 10 Full backupsThen make a TLog backupYou can restore any of those Full backups, and the TLog backup and you will be back to the "now" state.Put another way:You can restore Last Nights full backup and all Tlog backups since.But, if Last Night's backup is corrupted you can restore the previous night's Full backup and ALL Tlog backups since and you are fine (assuming all Tlog backups are not corrupted ) |
 |
|
|
|
|
|
Backup and Restore Help