We help IT Professionals succeed at work.
Get Started

Transactions logs not clearing after user migration to DAG databases from non DAG database

137 Views
Last Modified: 2016-03-14
We have recently started moving users from non replicated databases to DAG databases.
The migration was done using the EAC. And thus it generated large amount of transaction logs.
Microsoft KB 2800556 indicates this issue.

And since then the Veeam application aware backups have been failing to clear the transaction logs.
Also the snapshot creation during Veeam backups takes a long time (close to half hour).
And during the snapshot deletion it said that backup was successfull but it could not clear transaction logs
Has anyone seen this problem? Could it be related to VSS timeout as Veeam uses Microsoft VSS writers?

Is it OK to enable circular logging temporarily to clear these logs?
I will be doing this outside the backup window as the following article suggests that if circular logging is enabled during the backup operation or the recovery operation, you cannot restore individual databases:-
https://msdn.microsoft.com/en-us/library/office/dd877017(v=exchg.150).aspx#bk_circularlogging 

And will Veeam backups be able to clear the logs there after?
Comment
Watch Question
Infrastructure Director
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE