Hello,
We are taking a SQL aware VMware snapshot backup for a SQL VM and the backups/restores are all runnign fine. But the timestamp for the backup date in the SQL studio is not getting updated. It is still reflecting an old date when it was backed up via Avamar which is stopped now as we moved to netbackup and used snapshot backups.
Has anyone any idea how to fix this? How can NBU inform SQL that the DB has been backed up and it can update the timestamp?
NBU version - 8.3
SQL version - Microsoft SQL Server Enterprise 2014
DBA is running the below query to fetch the backup timestamp:
SELECT CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
msdb.dbo.backupset.database_name,
MAX(msdb.dbo.backupset.backup_finish_date) AS last_db_backup_date
FROM msdb.dbo.backupmediafamily
INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
WHERE msdb..backupset.type = 'D'
GROUP BY msdb.dbo.backupset.database_name
ORDER BY msdb.dbo.backupset.database_name
and it doesnt provide the updated backup time for the backup taken by Netbackup.
