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.
Backup failing with error 41 (SQL)
Whenattempting to take backup SQL from server as full backup it finishes successfully, and after that when attampting to take backup diffrential backup from the same server it failes with error 41 "network connection timed out". and the data base is stripped in to 4 stripes.
Restore SQL Server from Tape Backup
Hi guys, I have to admit that I am very new for all the Netbackup things. Briefly.... I have 2 NBU server which are not in the same cluster. NBU1 is DC site , NBU is DR site. I have to get the tape backup from NBU1 to restore at NBU2. I have done the Phase 1, Phase 2 import and restore perfectly on VMware. But the problem I am facing right now is how to restore SQL server from data imported NBU2 to the new virtual machine.(Windows Server 2012) Netbackup is 7.6.1 I create a new virtual machine and already installed SQL Server, MS SQL Client, grant permission for user. Thanks in advance. I am very desparate.......SQL Backup with different policy type
Currently, We are taking backup of SQL database in flat file (backup of .bkp file) usingNetBackup 7.7.3. We are thinking about changing it from flat file backup to application backup using NetBackup SQL policy. Which is better in both if we compare it on behalf ofbandwidth, security, restoration,bandwidth utilizationand other parameters? In current sitution this backup of this policy takes approximately 16 hr to finish. Will it improve after changing the policy and minimize the backup time?
