Forum Discussion

anash7's avatar
anash7
Level 4
4 years ago

Backup timestamp not getting updated in SQL Studio for VMware SQL aware backups

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.

  • Not sure how or why, but after upgrading to NBU 9.1, the SQL DB is reflecting the updated backup dates.