MS SQL transaction log issue, or not.

Availability for the Always-On Enterprise

MS SQL transaction log issue, or not.

Veeam Logoby sasilik » Mon Jan 16, 2017 11:49 am

I am not sure if following is problem or not but I had a case where I wanted to stop all SQL transaction log jobs and could not. I disabled backup jobs with MS SQL VM's and waited but two jobs stayed in Running status. If I went and looked at them then VM's in these jobs were not in Pending status but "In Progress" for more than 200 hours. If I remember correctly they were doing something "Saving log...". As VEEAM sends backup logs to mailbox I went and looked at previous log files and they indicated that previous backups were successful. I forced jobs to stop as https://www.veeam.com/kb1727 instructed. And they were stuck again when I started them and they started saving log files. After looking around I found that there were .bak file with date about 20 days ago in C:\ProgramData\Veeam\Backup\SqlLogBackup in MS SQL VM and it didn't disappear even when transaction log job backed logs up, made new .bak file and deleted new one after backing it up. So I stopped all jobs again, deleted old .bak files in MS SQL VM's, started jobs again and problem was solved. I am not sure how this situation happened, maybe restart of VEEAM or SQL servers when transaction log job was doing its job, but it seems to me that there should be some error handling or notification or something. It seems to be some problem but in same time backups actually worked so its kind of problem(can't stop transaction log jobs) and same time not problem(backups actually work). Any comments or similar cases from someone?
sasilik
Enthusiast
 
Posts: 34
Liked: 1 time
Joined: Thu Jun 12, 2014 11:01 am
Full Name: Markko Meriniit

Re: MS SQL transaction log issue, or not.

Veeam Logoby lreese » Mon Jan 16, 2017 1:23 pm

So your old backup files were not being removed before creating new backup files?
lreese
Novice
 
Posts: 8
Liked: 1 time
Joined: Tue Aug 30, 2016 12:38 pm
Full Name: Logan Reese

Re: MS SQL transaction log issue, or not.

Veeam Logoby sasilik » Mon Jan 16, 2017 1:50 pm

Yes, seems that in some point the .bak file was not removed. And I don't know what was the reason.
sasilik
Enthusiast
 
Posts: 34
Liked: 1 time
Joined: Thu Jun 12, 2014 11:01 am
Full Name: Markko Meriniit

Re: MS SQL transaction log issue, or not.

Veeam Logoby foggy » Tue Jan 17, 2017 4:32 pm

Markko, logs review is required to verify the reason of why the old log backup was not deleted - looks like its processing hung at some stage. Please contact support if you'd like to investigate this.
foggy
Veeam Software
 
Posts: 15275
Liked: 1131 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: DGrinev, foggy, Google [Bot], gpeachey, mats.jansson@atea.se, n.vanuffelen, vitaliy.shende and 1 guest