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.
-
- Enthusiast
- Posts: 80
- Liked: 4 times
- Joined: Apr 16, 2012 11:44 am
- Full Name: Justin Adams
- Location: United States
- Contact:
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Sharepoint SQL logs not truncating.
Justin, do you have any related messages in the Windows Event Log?
-
- 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.
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
FWIW, My environment matches identically. ESXi5.1, Server 2008 R2 and SQL 2008R2, Veeam 6.5.
Thanks
-
- 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.
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.
There are no errors or warnings in the logs of the SQL server.
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Sharepoint SQL logs not truncating.
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?
Who is online
Users browsing this forum: Bing [Bot] and 29 guests