-
- Veteran
- Posts: 284
- Liked: 11 times
- Joined: Jan 06, 2011 8:33 am
- Contact:
SQL Server Transaction lag Backup shows only one Instance
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
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
-
- Product Manager
- Posts: 9847
- Liked: 2605 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
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.
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
-
- Veteran
- Posts: 284
- Liked: 11 times
- Joined: Jan 06, 2011 8:33 am
- Contact:
Re: SQL Server Transaction lag Backup shows only one Instance
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 .
For both Instances the Veeam Backup User has under Security / Logon the Right "sysadmin"
Michael
Will open an Ticket .
-
- Veteran
- Posts: 3077
- Liked: 455 times
- Joined: Aug 07, 2018 3:11 pm
- Full Name: Fedor Maslov
- Contact:
Re: SQL Server Transaction lag Backup shows only one Instance
Hi Winston,
Would you be able to share your case ID here for reference?
Thank you!
Would you be able to share your case ID here for reference?
Thank you!
-
- Veteran
- Posts: 284
- Liked: 11 times
- Joined: Jan 06, 2011 8:33 am
- Contact:
Re: SQL Server Transaction lag Backup shows only one Instance
Open an Support Case , Support ID: #02446399
-
- Veteran
- Posts: 3077
- Liked: 455 times
- Joined: Aug 07, 2018 3:11 pm
- Full Name: Fedor Maslov
- Contact:
Re: SQL Server Transaction lag Backup shows only one Instance
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
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
Who is online
Users browsing this forum: No registered users and 61 guests