0

Database log file is 99% used.and sys.databases says LOG_BACKUP.Will manual log backup affect the AlwaysOn ? and like log shipping will AlwaysOn have log backup jobs ? Shrinking fails because of pending log backup ? Please advice should I create a maintenance plan for regular log backups ?

closed as unclear what you're asking by Philᵀᴹ, Vérace, dezso, Tom V, LowlyDBA Jul 27 '16 at 19:27

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

1

Will manual log backup affect the AlwaysOn ?

No Manual Log backups wont affect,this is same like you are doing through scheduled jobs..In Summary

Log backups can happen on any node and the log still gets truncated. The transaction log is basically replicated amongst all replicas.

like log shipping, will AlwaysOn have log backup jobs

AlwaysOn is similar to Mirroring in areas where log will be transferred over wire..

From Bob Dorr article

Always On is a bit different than database mirroring (DBM) with respect to sending the log blocks to the secondary replica(s). DBM flushes the log block to disk and once completed locally, sends the block to the secondary.

Always On changed this to flush the block(s) in parallel. In fact, a secondary could have hardened log block(s) before the primary I/O completes. This design increases performance and narrows the NOT IN SYNC window(s).

Shrinking fails because of pending log backup
if you are saying can i shrink log to reduce space.Don't do that,shrinking is a bad practice.Log space will be reused .Taking into Account factors that can prevent log space reuse,you also need to account for fact that replicas have hardened the log blocks to Disk

References:
https://blogs.msdn.microsoft.com/sqlgardner/2012/07/18/sql-2012-alwayson-and-backups-part-1-offloading-the-work-to-a-replica/

  • Thank you @TheGameiswar for clearing my long ago doubts and it is so helpful now. – SQLBoy Jul 27 '16 at 9:17

Not the answer you're looking for? Browse other questions tagged or ask your own question.