Page 1 of 1

SQL DB backup not working on one server

Posted: Nov 08, 2017 8:36 pm
by dsegel
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?

Re: SQL DB backup not working on one server

Posted: Nov 09, 2017 10:50 am
by PTide
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

Re: SQL DB backup not working on one server

Posted: Nov 09, 2017 3:20 pm
by dsegel
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.

Re: SQL DB backup not working on one server

Posted: Nov 09, 2017 4:48 pm
by dsegel
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.

SQL DB backup Incremental + Retention Period

Posted: Oct 27, 2018 6:50 pm
by SUBASHSACHIN
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

Re: SQL DB backup not working on one server

Posted: Oct 29, 2018 12:28 pm
by foggy
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.