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 |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2007-01-25 : 11:42:52
|
| Hello,When hourly transcation log backups are taken , is any log sequence number(LSN) generated .I want to know if this is right or wrong.I do the T-log backups until 10.00 pm and I do the complete DB backup at 12.00 AM. So the complete DB backup contains the DB and the T-log from 10.00 pm till 11.59 pm. So, is my understanding right.Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-26 : 02:42:45
|
| The full backup contains the database "state" at 12:01AM (or whenever the backup finishes, rather than when it starts)The next Tlog backup after midnight will contain the transactions since the previous LOG backup (i.e. some before the full backup, some after)If you need to restore using that Full backup, and then the next Tlog backup, only the "second half" of the TLog backup will be used - i.e. the part after 12:01AM(For this reason I take a TLog backup immediately before a full backup to reduce the amount of effort if a recovery is needed, avoiding restoring TLog backup files which contain LSNs that are not required)Kristen |
 |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2007-01-26 : 12:23:52
|
| Thanks for the explination kristen.vaddi |
|
|
|
|
|
|
Doubt with LSN