how to truncate Exchange 2016 DAG DB transaction log..?

faizal C
faizal C used Ask the Experts™
on
We have Exchange server 2016 DAG (2).transaction log is increasing . we are facing storage issue.So how to truncate transaction log..?

We tried below steps but no result.
1. VSS Full Backup active DB

Please suggest any solution to truncate log file.

regards,
Faizal
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
EE Solution Guide - Technical Dept Head
Most Valuable Expert 2017
Commented:
Hi Faisal,
Welcome to Experts Exchange.
Please try to enable circular logging on the database, Dismount and mount again.
Set-MailboxDatabase -identity Mailboxdatabase01  -CircularloggingEnabled:$true

Open in new window

https://technet.microsoft.com/en-us/library/dn756374(v=exchg.150).aspx

Recommended to have an Exchange known backup to clear the logs as it is not recommended to have circular logging enabled.

Run this command and see Microsoft Exchange Write is listed or no. If not listed please update to latest CU. i.e. CU9 https://www.microsoft.com/en-us/download/details.aspx?id=56718
vssadmin list writers

Open in new window


Thanks
MAS
faizal CConsultant

Author

Commented:
hi,

thanks for your replay..

Microsoft exchange writer listed.

can you suggest any other method ?. I cant understand why transaction log truncate after DAG group added.

If you have any idea, please replay me.

Circular logging enable - this option i will do if i didn't get another solution
MASEE Solution Guide - Technical Dept Head
Most Valuable Expert 2017
Commented:
Please try to install Veeam free edition and run backup. See how it goes.
Please dont forget to enable "Application Aware processing" when creating the job.
Capture1.PNG
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

faizal CConsultant

Author

Commented:
hi,

Thanks.

Any solution available to DAG log truncate from Microsoft..?
MASEE Solution Guide - Technical Dept Head
Most Valuable Expert 2017

Commented:
Please install the latest CU and check.
faizal CConsultant

Author

Commented:
I have Latest
After successfull full or incremental backup logs should truncate, if not than there can h some problem..

Try to use script VSstester to simluate the backup if this works fine and logs get truncated there is no issue with exchange..

Please note this script only simulate the backup doesn't actually take it, however logs will be purged if this is successful

https://github.com/Microsoft/VSSTESTER
faizal CConsultant

Author

Commented:
Thanks for your suggestion,



How Loose Truncation Works and implement.. ?

Do you know this option..?
faizal CConsultant

Author

Commented:
is it possible for exchange 2016..?
Annie RoseTech Lead

Commented:
Check if this point you: https://community.spiceworks.com/topic/739213-how-to-manually-clear-exchange-2013-logs

How to Move and Truncate Logs in Exchange Server 2013:
http://expert-advice.org/exchange-server/move-truncate-logs-exchange-server-2013/

To Enable Circular logging:

Get-mailboxdatabase | Set-MailboxDatabase  -CircularLoggingEnabled:$True

Open in new window


To Disable Circular logging:

Get-mailboxdatabase | Set-MailboxDatabase  -CircularLoggingEnabled:$False

Open in new window

MASEE Solution Guide - Technical Dept Head
Most Valuable Expert 2017

Commented:
Enough information to confirm answer.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial