We have avamar tool taking backups in my environment. The backup plan avamar does is only taking trans backups once a day. I am convincing them to take the trans backup more frequent. But in the meanwhile, I have to deal with large log sizes because of this infrequent trans backups. Hence to reduce the log sizes, I am taking a quick trans backup followed by a truncate log size. Now I want to know if doing that breaks the log chain for avamar and it forces it to take full back up instead. Remember, I am deleting the trans backup file immediately after I truncate the log sizes. Does the fact that I deleted the trans backup file breaks the log chain for Avamar? Any input is appreciated.
Sql-server – Does taking a log backup, truncating the log, and then deleting the tlog backup break the LSN chain
backupsql servertransaction-log
Related Question
- SQL Server 2008 R2 – First Log Backup After Full Backup Takes Up Space
- SQL Server – Log File Not Shrinking After Growth and Backup
- Sql-server – At which point in a log backup does SQL Server truncate the log file
- Sql-server – After a full backup, how does system know which transactions to restore from the transaction log backup
- Sql-server – SQL Server shrink log after full and log backup
- Sql-server – Trans Log fills during delete, conceptual question
- SQL Server – Why Add NO_TRUNCATE and NORECOVERY Options in Tail Log Backup
Best Answer
If the avamar tool uses its own tracking method to know what log backup files it can restore, then it will fail.
If it uses SQL internal tables to know what log backup it needs, that is good, but if the file has been deleted, then it will fail.
Either way it will fail since you are deleting the files...so don't :)