Is my SQL transaction log backup working?

VMware specific discussions

Is my SQL transaction log backup working?

Veeam Logoby pufferdude » Wed Mar 16, 2016 6:28 pm

Yesterday I enabled backup of SQL transaction logs in V9 and I see the new "[VM] SQL Server Transaction Log Backup" job running continuously, but I'm not sure if it's working right. I can see that a new .vlb file gets created every time an image backup occurs, and every 15min between the image backups I see the timestamp on the .vlb file change, presumably with the latest log data.

However, when I look a the statistics for the running SQL log job, I see "Success: 1" and no warning or errors. I was expecting to see the success number = to the number of times the job successfully backed up the log... am I interpreting this wrong? In summary: It looks like my logs are being backed up, but I'm confused by what I'm seeing in the job stats.
pufferdude
Expert
 
Posts: 126
Liked: 4 times
Joined: Thu Jul 02, 2009 8:26 pm
Full Name: Jim

Re: Is my SQL transaction log backup working?

Veeam Logoby pufferdude » Wed Mar 16, 2016 6:32 pm

Ah, nevermind... I think I figured it out. The panel I'm looking at is for the "Last Period" and since I only have a single VM in the job, there's a single success :D If I click on the VM itself the total sessions stats are revealed. Duh.
pufferdude
Expert
 
Posts: 126
Liked: 4 times
Joined: Thu Jul 02, 2009 8:26 pm
Full Name: Jim

Re: Is my SQL transaction log backup working?

Veeam Logoby Vitaliy S. » Mon Mar 21, 2016 11:58 am

On a side note, if you're using Availability Suite, then this report might come in handy.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to VMware vSphere



Who is online

Users browsing this forum: Google [Bot] and 7 guests