Force NBSERVER setting in an MSSQL Intelligent policy batch file
Hello I have a new Netbackup 5250 appliance that is taking backups for a Production and Lab environment. The Management Interface of the Appliance is configured in the Production environment. The Appliance has different NICs configured on the Prod and Lab networks for backup payload data. I have a problem with Lab MSSQL intelligent policies that wants to use the Production Management Interface for backups. Since the Lab network does not have access to the Prod network, the Lab MSSQL client cannot be backed up using the Management Interface of the Appliance. I was able to grab the .bch file that is auto-generated on the client to see the NBSERVER setting and it is the Appliance Prod hostname. So my question is, is it possible to force/override the NBSERVER setting in the autogenerated .bch file for Intelligent MSSQL Policies? The same client is able to be backed-up in a regular Windows policy since it is using the right hostname of the Appliance. Example in the auto-generated .bch file: Instead of, NBSERVER = "Prod5250hostname" (this is the autogenerated config right now) I want NBSERVER = "Lab5250hostname" (same appliance but different network interface) I could create a DNS entry in the Lab DNS server to point to the IP of the Appliance Lab interface, but I would like to avoid that. Thank you.
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.
SQL query - Backup policy report
Hi, I'm trying to get a report with the following fields "Policy Name" "GB Written" "Master Server" I tried to get the report by 2 ways SELECT distinct d.policyName AS "Policy Name", CAST(SUM(d.sizeOfImageInKBytes)/1024/1024/1024 AS DEC(8,2)) AS "GB Written", m.masterServerName AS "Master Server" FROM domain_image d, nom_NBJob m WHERE DATEDIFF(day,UTCBigIntToNomTime(d.writeEndTime), GETDATE()) <= 1 AND d.masterServerId=nom_NBJob.masterServerId GROUP BY d.policyName, m.masterServerName ORDER by 1 SELECT distinct d.policyName AS "Policy Name", CAST(SUM(d.sizeOfImageInKBytes)/1024/1024/1024 AS DEC(8,2)) AS "GB Written", m.masterServerName AS "Master Server" FROM domain_image d INNER JOIN nom_NBJob AS m ON d.masterServerId=m.masterServerId AND DATEDIFF(day,UTCBigIntToNomTime(d.writeEndTime), GETDATE()) <= 1 AND d.backupStatus=0 GROUP BY d.policyName, m.masterServerName ORDER by 1 But both queries are taking much time to get the information, is there a way to improve the performance of the query or another query to get the required information?
Backup failing with error 41 (SQL)
When attempting 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.......