Knowledge Base & Discussion Forum

Transaction log keeps growing

Discuss issues about AhsayOBM's MS SQL Server Database backup and restore

Moderator: Support Team

Transaction log keeps growing

Postby Madtho72 » Tue Dec 19, 2017 9:06 pm

Using 7.15.0.20 both server and Client.
SQL 2012 (11.0.5343)
Windows 2012 R2

Recoverymode is on FULL
runs following SQL backups
Full Backup Scehdule ; FULL Friday 23:00
Incremental Backup Schedule; Incremental Weekly mon, thu, wen and thursday 23:00

ldf keeps growing, and mdf stays on same side. So nothing seems to be truncated.
According to log, all backups are successful.

So my question is, why does it not truncate LDF file ???
Last time i hade to change recovery to simple, do a SQL backup from sql manager, then truncate log and set it back to Full recovery to let Ahsay do backups....

hope to solve this
Regards
Thomas
Madtho72
 
Posts: 2
Joined: Fri Nov 15, 2013 8:41 pm

Re: Transaction log keeps growing

Postby Richard Au » Wed Dec 20, 2017 3:52 pm

Hi Thomas,

To help us looking into this issue, can you please contact our support to verify on this? Please submit your case through our ticket system at https://ahsay.com/jsp/en/contact/kbQuestion.jsp
Richard Au
Ahsay Forum Support Team
User avatar
Richard Au
 
Posts: 241
Joined: Wed Aug 31, 2016 10:43 am

Re: Transaction log keeps growing

Postby Rylos » Wed Jan 17, 2018 2:31 am

Thomas,

Did you figure out this issue here? I noticed this same thing today and had to manually shrink my transaction logs.

-Ryan
Rylos
 
Posts: 35
Joined: Tue Dec 30, 2014 8:34 pm

Re: Transaction log keeps growing

Postby Madtho72 » Tue Apr 03, 2018 8:05 pm

No, did send in a "case" but havent heard back..
Madtho72
 
Posts: 2
Joined: Fri Nov 15, 2013 8:41 pm

Re: Transaction log keeps growing

Postby Richard Au » Wed Apr 04, 2018 10:24 am

Hi,

Madtho72 wrote:No, did send in a "case" but havent heard back..


Please let us know the ticket ID and I will have the support engineer to look into your case soon.
Richard Au
Ahsay Forum Support Team
User avatar
Richard Au
 
Posts: 241
Joined: Wed Aug 31, 2016 10:43 am


Return to Microsoft SQL Server Database

Who is online

Users browsing this forum: No registered users and 1 guest

Looking for Rbackup Alternative | Vembu Alternative | Novastor Alternative | Asigra Alternative | BackupAgent Alternative? Try our product.


A wholly owned subsidiary of Ahsay Backup Software Development Company Limited  [HKEx Stock Code: 8290]