Discussions specific to the VMware vSphere hypervisor
Post Reply
jadams159
Enthusiast
Posts: 80
Liked: 4 times
Joined: Apr 16, 2012 11:44 am
Full Name: Justin Adams
Location: United States
Contact:

Sharepoint SQL logs not truncating.

Post by jadams159 »

Yesterday I Enabled Application Aware Processing and set the Advance section to truncate logs on successful backup. The job completed successfully, however the .LDF file sizes did not change, so I'm assumming that they weren't truncated. However, in the job details there is a step for "Truncating transaction logs" with a green checkmark, and it took 22 minutes.

The DBs in question are in Full Recovery mode.

foggy
Veeam Software
Posts: 19437
Liked: 1764 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sharepoint SQL logs not truncating.

Post by foggy »

Justin, do you have any related messages in the Windows Event Log?

jadams159
Enthusiast
Posts: 80
Liked: 4 times
Joined: Apr 16, 2012 11:44 am
Full Name: Justin Adams
Location: United States
Contact:

Re: Sharepoint SQL logs not truncating.

Post by jadams159 »

I don't have any 3041 Event IDs in the logs. The application logs stated that each DB and Log files was backed up successfully.

FWIW, My environment matches identically. ESXi5.1, Server 2008 R2 and SQL 2008R2, Veeam 6.5.

Thanks

jadams159
Enthusiast
Posts: 80
Liked: 4 times
Joined: Apr 16, 2012 11:44 am
Full Name: Justin Adams
Location: United States
Contact:

Re: Sharepoint SQL logs not truncating.

Post by jadams159 »

2 days of successfull, application aware backups and my .ldf sfiles are still huge. No ideas?

There are no errors or warnings in the logs of the SQL server.

Vitaliy S.
Product Manager
Posts: 24243
Liked: 1859 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Sharepoint SQL logs not truncating.

Post by Vitaliy S. »

I'm afraid that job debug logs review is required. Can you please contact our technical team and post your support case number for future reference?

Post Reply

Who is online

Users browsing this forum: No registered users and 39 guests