Transactionlog Backups only fron one Instance of SQL Server

[WinstonWolf]

Hello ,
When i check my Transaction Log Backups of an SQL Server , i only see the Log Backups from one Instance . But on this Server there are two Instances .
On the other Instance the Veeam Backup User hast Logon Rights and the Databases are also at Status "Full" Backup .
So why i dont see the SQL LogBackups only from one Instance ?

Thanks
Michael

[HannesK]

Hello,
could you maybe explain more where you see the logs for the first instance (screenshot)? The console shows logs "per server" and in the file system it's the same.

Best regards,
Hannes

[PetrM]

Hello,

You can try this query in SSMS to get all log backups information for any database from any instance:

Code: Select all

select * from msdb.dbo.backupset where type ='L' and database_name = <<your database name>>

Also, more options to retrieve this information are described in this topic.

Thanks!