How generating bch for SQL restore retrieves database informations
Hi, I'm trying to make a Powershell script to automate the restore process of the SQL Server databases It's clear for me how to do it, but the only things I can't get are the SQL path informations (TO directive) and SQL logical name informations (MOVE directive) that are generated into the bch file during restore process Thanks in advance dbSolved1.2KViews0likes4CommentsUniversal Shares Use Cases
Been reading through all the admin guides and came accross Universal Shares. Wondering what the use case is? Prior to 3.2. it seems it was just a NFS/CIFS share with Deduplication enabled against it but no other direct integration witn NetBackup. From 3.2 we have Protection Points: "Starting with appliance release 3.2, the Protection Point feature supports direct integration with NetBackup. A Protection Point is a point in time copy of the data that exists in a Universal Share. Creation and management of a Protection Point is accomplished through a NetBackup policy, which defines all scheduling and retention of the Protection Point. The Protection Point uses the same "Standard" policy type that is used for UNIX/Linux systems. Once a Protection Point for the data in the Universal Share is created, that point in time copy of the Universal Share data can be managed like any other protected data in NetBackup. Protection Point data can be replicated to other NetBackup Domains or migrated to other storage types like tape or cloud, using Storage Lifecycle Policies. Each Protection Point copy is referenced to the name of the associated Universal Share." This seems useful! Is anyone using it and what use cases have you for it? Feedback would be much appreciated!:smileyvery-happy:2.6KViews1like9CommentsNetbackup script to check what all active clients do not have full backup from last 1 month
Hi ALL, I need a Netbackup script to check what all active clients do not have full backup from last 1 month.(active clients only and not for clients which are in the deactivated policy) or a SQL query for OPSCENTER Analytics will also help.4.7KViews0likes11CommentsAlternate media server while duplicating backups
Hello, I started a duplication job of many backups that are on a DataDomain storage server, the destination is a tape library and I'm using a STU with one media server selected which is the only that have access to the tape drives However, when the job starts, for every single backup image, NetBackup do one ore more attempts to read the image using a media server that is not selected in the storage unit. e.g. Media server in the STU = media15 What I see in the job detail = "Media server: media09 -> media15" A bpimagelist of the backup image, says that media09 is not the server that has been used to do the copy whose duplicate is running master is a Windows 2012 with NBU 8.1.2 media15 is a Windows 2008 with NBU 8.1.2 media09 is a RHEL 6 with NBU 7.7.3 Is this behaviour by design? Thank you db858Views0likes3CommentsBacking up Microsoft Exchange 2016
Hello all, Let me explain our situation regarding the subject above. We have this Microsoft Exchange 2016 (2 mailbox Exchange nodes). At first the Exchange server was backed up using the production IP which need to traverse thru the firewall to reach Netbackup and the backup is slow and taking time to finish. Later, we assigned dedicated IPs for backup purposes (since Exchange running on VMware, the VMware team add another VNIC) to each Exchange nodes so it will eliminate the issue of backup slowness. But our situation here, since the Exchange servers are clustered with (DAG) and in the backup policy we need to point to the cluster name (DAG), it seems like the backup still using the production IP that need to go thru firewall and still have the issue with backup slowness. The way the Exchange administrator setup their Exchange mailbox, there are 4 mailboxes that divided into 2 mailboxes for each Exchange node. Could we point the backup directly (in the backup policy) to the Exchange node to backup the email? We have ask the Veritas support but they respond it is not the correct way to backup directly to the Exchange node. It must pointing to DAG cluster name. Please advice.Solved2KViews0likes3CommentsThe strange inexistent FQDNs in the bpdbm.logs
Enviroment: NBU 8.1.1 on RHEL 6.9 Symptom: 1) There are many hostname resolution entries about the vnet_cached_getaddrinfo with their inexistent FQDNs in the bpdbm.logs: Notes: They are the host short-names used by the master/media server in the bp.conf, those are also resolved via the /etc/hosts. 20:30:23.383 [753] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=sh2db4.sh.sgcc.com.cn SVC=NULL 20:30:32.866 [944] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=sh2db4.sh.sgcc.com.cn SVC=NULL 20:30:35.731 [978] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=shzycdb2.sh.sgcc.com.cn SVC=NULL 20:30:43.873 [1067] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=sh2db4.sh.sgcc.com.cn SVC=NULL 20:30:47.148 [1094] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=shzycdb2.sh.sgcc.com.cn SVC=NULL 20:31:00.222 [1228] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=shzycdb4.sh.sgcc.com.cn SVC=NULL 20:31:06.028 [1323] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=sh2db2.sh.sgcc.com.cn SVC=NULL 20:31:12.725 [1427] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=shzycdb4.sh.sgcc.com.cn SVC=NULL 20:31:21.955 [1532] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=shzycdb2.sh.sgcc.com.cn SVC=NULL 20:31:23.532 [1548] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=shzycdb2.sh.sgcc.com.cn SVC=NULL 20:31:23.944 [1559] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=sh2db2.sh.sgcc.com.cn SVC=NULL 20:31:39.127 [1652] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=sh2db2.sh.sgcc.com.cn SVC=NULL 20:31:51.366 [1696] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=sh2db2.sh.sgcc.com.cn SVC=NULL 20:33:20.655 [2047] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=gw2db1.sh.sgcc.com.cn SVC=NULL 20:33:25.077 [2093] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=gw2db1.sh.sgcc.com.cn SVC=NULL 20:33:42.105 [2161] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=shzycdb1.sh.sgcc.com.cn SVC=NULL 20:33:45.389 [2175] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=gw2db1.sh.sgcc.com.cn SVC=NULL 20:33:59.405 [2236] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=jcsjdb3.sh.sgcc.com.cn SVC=NULL 20:34:00.868 [2253] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=jcsjdb3.sh.sgcc.com.cn SVC=NULL SERVER = jcbak <--- master server MEDIA_SERVER = jcsjdw1 MEDIA_SERVER = jcsjdb2 MEDIA_SERVER = jcsjdb3 MEDIA_SERVER = sh2db1 MEDIA_SERVER = sh2db2 MEDIA_SERVER = sh2db3 MEDIA_SERVER = sh2db4 MEDIA_SERVER = sh2db5 MEDIA_SERVER = gmdfwq1 MEDIA_SERVER = gmdfwq2 MEDIA_SERVER = gmdfwq3 MEDIA_SERVER = shzycdb1 MEDIA_SERVER = shzycdb2 MEDIA_SERVER = gw3db3 MEDIA_SERVER = gw3db4 MEDIA_SERVER = ecmweb1 MEDIA_SERVER = gw3db1 MEDIA_SERVER = gw3db2 # # nbemmcmd -listhosts -verbose -display_server -machinename jcbak -machinetype master NBEMMCMD, Version: 8.1.1 jcbak ClusterName = "" MachineName = "jcbak" FQName = "jcbak" GlobalDriveSeed = "VEND:#.:PROD:#.:IDX" LocalDriveSeed = "" MachineDescription = "" MachineFlags = 0x77 MachineNbuType = master (3) MachineState = active for tape and disk jobs (14) NetBackupVersion = 8.1.1.0 (811000) OperatingSystem = linux (16) ScanAbility = 5 Command completed successfully. # # # # nbemmcmd -listhosts -verbose -display_server -machinename jcsjdb3 -machinetype media NBEMMCMD, Version: 8.1.1 jcsjdb3 ClusterName = "" MachineName = "jcsjdb3" FQName = "jcsjdb3" LocalDriveSeed = "" MachineDescription = "" MachineFlags = 0x71 MachineNbuType = media (1) MachineState = active for tape and disk jobs (14) MasterServerName = "jcbak" NetBackupVersion = 8.1.1.0 (811000) OperatingSystem = linux (16) ScanAbility = 5 Command completed successfully. # # # # grep -Ei "jcbak|sjdb3" /etc/hosts 10.131.33.60 jcbak 10.131.29.105 jcsjdb3 # # 2) There are also some hostname resolution entries about the vnet_cached_getaddrinfo with their short-names in the bpdbm.logs: Notes: Those short hostname are also resolved via the /etc/hosts, and appear normally in the bpdbm.logs: 20:30:20.145 [710] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=srmprd2 SVC=NULL 20:30:20.146 [710] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=srmprd1 SVC=NULL 20:30:20.146 [710] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=erp-audit SVC=NULL 20:30:20.156 [710] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=SCERPDB1 SVC=NULL 20:30:20.157 [710] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1751] in failed file cache ERR=-2 NAME=EDWETL SVC=NULL MEDIA_SERVER = srmprd1 MEDIA_SERVER = srmprd2 MEDIA_SERVER = scerpdb1 # # # nbemmcmd -listhosts -verbose -display_server -machinename srmprd2 -machinetype media NBEMMCMD, Version: 8.1.1 srmprd2 ClusterName = "" MachineName = "srmprd2" FQName = "srmprd2" LocalDriveSeed = "" MachineDescription = "" MachineFlags = 0x13 MachineNbuType = media (1) MachineState = not reachable by master (4) MasterServerName = "jcbak" NetBackupVersion = 8.1.1.0 (811000) OperatingSystem = rs6000 (5) ScanAbility = 5 Command completed successfully. # # # # nbemmcmd -listhosts -verbose -display_server -machinename scerpdb1 -machinetype media NBEMMCMD, Version: 8.1.1 SCERPDB1 ClusterName = "" MachineName = "SCERPDB1" FQName = "SCERPDB1" LocalDriveSeed = "" MachineDescription = "" MachineFlags = 0x17 MachineNbuType = media (1) MachineState = not active (0) MasterServerName = "jcbak" NetBackupVersion = 7.5.0.0 (750000) OperatingSystem = rs6000 (5) ScanAbility = 5 Command completed successfully. # # #1.8KViews0likes9Comments