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 |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
 Posted - 2008-07-16 : 01:57:15
|
| I'm doing a Daily Full Backup and Hourly Log Backup on a particular 2000 database. If someone takes an ad-hoc Full Backup during the day will this break the chain of Hourly Logs as related to the nightly Backup?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 09:00:32
|
| It won't. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-16 : 12:56:05
|
| Neither full backups nor differential backups affect the transaction log chain. The chain is comprised of transaction logs, but you start the restore with a full backup, then diffs if needed/wanted, and the entire tlog chain you are interested in.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-17 : 01:21:41
|
| Thanks , I thought that was the case , obviously the thing to avoid is doing ad-hoc log truncates!Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-17 : 12:46:18
|
quote:
Originally posted by jackv
Thanks , I thought that was the case , obviously the thing to avoid is doing ad-hoc log truncates!Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
Yes, you are right. If you do , follow up with Full backup. |
|
|
|
|
|
|
Daily Full BackUp / Hourly Logs