Availability for the Always-On Enterprise
Post Reply
dsegel
Influencer
Posts: 13
Liked: never
Joined: Aug 09, 2017 3:51 pm
Full Name: Daniel Segel
Contact:

SQL DB backup not working on one server

Post by dsegel » Nov 08, 2017 8:36 pm

It's not finding any databases on one particular server:

Code: Select all

11/8/2017 12:19:25 PM :: New transaction log backup interval started at 11/8/2017 12:19:25 PM
11/8/2017 12:19:25 PM :: Enumerating SQL Server databases
11/8/2017 12:19:33 PM :: Starting SQL Server transaction log backup retention processing
11/8/2017 12:19:33 PM :: Deleted 2 SQL Server transaction log backups for time period from 11/1/2017 12:16:10 PM to 11/1/2017 12:16:11 PM
11/8/2017 12:19:33 PM :: SQL Server transaction log backup retention processing completed
11/8/2017 12:19:34 PM :: Transaction log backup completed at 0.0 KB/s with bottleneck: N/A
I've tried turning guest processing off and on, rebooting the VBR server, checking permissions, etc. but nothing makes it work. It used to work, then stopped a few days ago.

Any tips on how to fix or debug this?

PTide
Veeam Software
Posts: 4663
Liked: 386 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SQL DB backup not working on one server

Post by PTide » Nov 09, 2017 10:50 am

Hi,

The log that you've provided is related to transaction log backup, not to DB backup. What are the settings of the backup job that you use to backup your DB server (schedule, transaction log processing settings)?

Thanks

dsegel
Influencer
Posts: 13
Liked: never
Joined: Aug 09, 2017 3:51 pm
Full Name: Daniel Segel
Contact:

Re: SQL DB backup not working on one server

Post by dsegel » Nov 09, 2017 3:20 pm

Sorry, I may have the terminology wrong. The VM itself is backed up every night around 7pm. The VM backup itself completes without any errors.

I have Guest Processing turned on with these options:

Enable application-aware processing is checked.

For Application-Aware Processing Options,
Under General:
Require successful processing
Process transaction logs with this backup

Under SQL:
Backup logs periodically (every 15 minutes)
Keep only last 7 days of log backups

Guest OS Credential is using an account that is in the local Administrators group, and has been added to the database in question as a dbo and sysadmin.

The guest interaction proxy test completes successfully.

dsegel
Influencer
Posts: 13
Liked: never
Joined: Aug 09, 2017 3:51 pm
Full Name: Daniel Segel
Contact:

Re: SQL DB backup not working on one server

Post by dsegel » Nov 09, 2017 4:48 pm

Aaaaand it's working again. I changed the Guest interaction proxy from 'Automatic' to all but one specific server that's on a different subnet and on the other side of a WAN VPN tunnel, and it works now. I noticed somewhere that it was trying to use that server as a proxy, which doesn't make sense since the bandwidth to it is so much slower than all the others, so I removed it from the options.

SUBASHSACHIN
Lurker
Posts: 1
Liked: never
Joined: Oct 27, 2018 6:35 pm
Full Name: Subash
Contact:

SQL DB backup Incremental + Retention Period

Post by SUBASHSACHIN » Oct 27, 2018 6:50 pm

Dear Team,
We are going to buy a Veeam application for SQL DB backup / Replica Site to site / Cloud / Failover & Failback

1. We are using SQL Important DB and we are taking the backup Weekly Full and every 10 minutes incremental and DB retention period 5 Years .. an Example if our DBA some time asking particular Point in time an example ( 12-July-2015 at 10:30 PM ) I can restored from my backup ( We are using EMC networker & DataDomain ) This above sample things can i do it via Veeam Backup ?

2. Replica Site to Site ( This veeam is it good)

I am Waiting for your valuable feedback

Regards
Subash.T

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

Re: SQL DB backup not working on one server

Post by foggy » Oct 29, 2018 12:28 pm

Hi Subash, yes, this configuration is possible with Veeam B&R. Such setup, however, will require well-spec'd Veeam B&R and SQL Server, since due to the large amount of logs restore points, there will be huge metadata file and a lot of items to process by SQL queries.

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 17 guests