Host-based backup of VMware vSphere VMs.
Post Reply
WinstonWolf
Veteran
Posts: 284
Liked: 11 times
Joined: Jan 06, 2011 8:33 am
Contact:

SQL Server Transaction lag Backup shows only one Instance

Post by WinstonWolf »

Good Morning ,

We have an SQL Server 2019 . On this Server there was two Instances and in every Instance some Databases .
But when i check my SQL Transaction Lag Backup Job then i see that only one from the both Instances shows upin the Details Window .
But in the other Instance there was also "Full"Backup Databases . But i cant see any Log Backup Information for the second Instance .

What goes there wrong ?

Thanks
Michael
Mildur
Product Manager
Posts: 8735
Liked: 2294 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: SQL Server Transaction lag Backup shows only one Instance

Post by Mildur »

Hi Michael

What is the recovery model for the databases in the other instance? If the db recovery model is simple, log backup for this databases will be automatically excluded.
Recovery Model

And make sure, that veeam has the enough permissions on the instance.
SQL - Required Permissions

If you have checked both, and the log backups are still not available, please open a support case and post the case number here for our reference.
Product Management Analyst @ Veeam Software
WinstonWolf
Veteran
Posts: 284
Liked: 11 times
Joined: Jan 06, 2011 8:33 am
Contact:

Re: SQL Server Transaction lag Backup shows only one Instance

Post by WinstonWolf »

In both Instances was Databases with Recovery Model "Full"

For both Instances the Veeam Backup User has under Security / Logon the Right "sysadmin"

Michael

Will open an Ticket .
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: SQL Server Transaction lag Backup shows only one Instance

Post by wishr »

Hi Winston,

Would you be able to share your case ID here for reference?

Thank you!
WinstonWolf
Veteran
Posts: 284
Liked: 11 times
Joined: Jan 06, 2011 8:33 am
Contact:

Re: SQL Server Transaction lag Backup shows only one Instance

Post by WinstonWolf »

Open an Support Case , Support ID: #02446399
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: SQL Server Transaction lag Backup shows only one Instance

Post by wishr »

Hi Winston,

This is the support ID, which is not the same as the number of the support case itself. Could you please check it one more time?

Thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 38 guests