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 |
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
 Posted - 2009-05-07 : 17:06:42
|
| Scenario exampleMonday Full backup (1)Tue Tran log backup (2)Wed Tran log backup (3)Thur Full backup (4)Fri Tran log backup (5)Can I recover to Fri byRestoring 1,2,3 & 5. Or does (4) prevent this from being possible?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-05-07 : 19:57:47
|
| Yes you can. You could do 1,2,3,5 or 4,5. For point-in-time recovery, you need some full backup and the entire transaction log chain up to the point in time. Daily full backups mean you'd have less files to apply, but you really could go back to the very first full backup on that system and do a point in time restore to right now if you had every single transaction log backup since the first full backup. Remember that truncating the transaction log breaks the chain.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-05-07 : 22:31:06
|
| Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-16 : 10:34:00
|
| I would recommend having backups to run every 15 minutes for the LOG files too so they don't become too large.Scenario example Monday Full backup (1) Tue Tran log backup (2)Wed Tran log backup (3)Thur Full backup (4)Fri Tran log backup (5)Can I recover to Fri byRestoring 1,2,3 & 5. Or does (4) prevent this from being possible? |
|
|
|
|
|
|
DB backup/restore question