cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

cant backup sql db

O-a
Level 4

‎09-09-2009 07:12 AM

hallo

when i  backup sql (netbackup 6.3.5)  on one of my sql server(2003 r2 sp2) the session stack with job state "active" for hours(even if the windows tie is closed)

when i'm start the job menualy i dont see the application or the db which i chose to backup.

the job status:

09/09/2009 16:26:34 - requesting resource ckupservbaer.NBU_CLIENT.MAXJOBS.sqlserver
09/09/2009 16:26:34 - requesting resource ckupservbaer.NBU_POLICY.MAXJOBS.sqlserver
09/09/2009 16:26:34 - granted resource ckupservbaer.NBU_CLIENT.MAXJOBS.sqlserver
09/09/2009 16:26:34 - granted resource ckupservbaer.NBU_POLICY.MAXJOBS.sqlserver
09/09/2009 16:26:34 - granted resource ckupservbaer-hcart3
09/09/2009 16:26:35 - estimated 0 kbytes needed
09/09/2009 16:26:35 - started process bpbrm (4596)
09/09/2009 16:26:36 - connecting
09/09/2009 16:26:37 - connected; connect time: 00:00:01



any ideas?
0 Kudos
9 REPLIES 9

rjrumfelt
Level 6

‎09-11-2009 07:59 AM

O-a,  could you run the following command

bppllist <policy_name> -U

and paste the output here?  This will let the folks on this forum see how you have your policy configured.  Does this backup kick off any child streams?  Or does the parent just hang without initiated child streams for this backup?
0 Kudos

O-a
Level 4

‎09-13-2009 12:47 AM

hi,

first, thanks for your help.

1.the parent does not hang if i dont canceled the job
2.i dont see any  child steams open for this server(I forgot to say the policy include with two SQL server.with the second server i dont have this problem)

i copied the Policy confuiguration:
------------------------------------------------------------

Policy Name:       sql_Policy

  Policy Type:         MS-SQL-Server
  Active:              yes
  Effective date:      04/27/2009 15:26:59
  Mult. Data Streams:  no
  Client Encrypt:      no
  Checkpoint:          no
  Policy Priority:     0
  Max Jobs/Policy:     Unlimited
  Disaster Recovery:   0
  Collect BMR info:    no
  Residence:           Master Server-hcart3
  Volume Pool:         Daily
  Server Group:        *ANY*
  Keyword:             (none specified)
  Data Classification:       -
  Residence is Storage Lifecycle Policy:    no

Granular Restore Info:  no
  HW/OS/Client:  PC            Windows2003   SqlSrv1
                 PC            Windows2003   SqlSrv2
  Include:  C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup.bch

  Schedule:          Monthly_App
    Type:            Application Backup
    Maximum MPX:     1
    Synthetic:       0
    PFI Recovery:    0
    Retention Level: 8 (1 year)
    Number Copies:   1
    Fail on Error:   0
    Residence:       (specific storage unit not required)
    Volume Pool:     Monthly
    Server Group:    (same as specified for policy)
    Residence is Storage Lifecycle Policy:     0
    Daily Windows:
          Saturday   01:00:00  -->  Saturday   07:00:00

  Schedule:          Mnthly_Sql
    Type:            Automatic Backup
    Synthetic:       0
    PFI Recovery:    0
    Retention Level: 3 (1 month)
    Calendar sched: Enabled
      SPECIFIC DATE 0 - 08/28/2009
    Residence is Storage Lifecycle Policy:     0
    Daily Windows:
          Saturday   01:00:00  -->  Saturday   07:00:00

  Schedule:          Weekly_Sql
    Type:            Automatic Backup
    Frequency:       every 7 days
    Synthetic:       0
    PFI Recovery:    0
    Retention Level: 3 (1 month)
      EXCLUDE DATE 0 - 08/28/2009
    Residence is Storage Lifecycle Policy:     0
    Daily Windows:
          Saturday   01:00:00  -->  Saturday   07:00:00

  Schedule:          daily
    Type:            Automatic Backup
    Frequency:       every 1 day
    Synthetic:       0
    PFI Recovery:    0
    Retention Level: 3 (1 month)
    Residence is Storage Lifecycle Policy:     0
    Daily Windows:
          Sunday     08:00:00  -->  Sunday     12:00:00
          Tuesday    00:20:00  -->  Tuesday    04:20:00
          Wednesday  00:20:00  -->  Wednesday  04:20:00
          Thursday   00:20:00  -->  Thursday   04:20:00
          Friday     00:20:00  -->  Friday     04:20:00

  Schedule:          Daily_App
    Type:            Application Backup
    Maximum MPX:     3
    Synthetic:       0
    PFI Recovery:    0
    Retention Level: 3 (1 month)
    Number Copies:   1
    Fail on Error:   0
    Residence:       (specific storage unit not required)
    Volume Pool:     Daily
    Server Group:    (same as specified for policy)
    Residence is Storage Lifecycle Policy:     0
    Daily Windows:
          Sunday     08:00:00  -->  Sunday     12:00:00
          Tuesday    00:20:00  -->  Tuesday    04:20:00
          Wednesday  00:20:00  -->  Wednesday  04:20:00
          Thursday   00:20:00  -->  Thursday   04:20:00
          Friday     00:20:00  -->  Friday     04:20:00

  Schedule:          Weekly_App
    Type:            Application Backup
    Maximum MPX:     1
    Synthetic:       0
    PFI Recovery:    0
    Retention Level: 3 (1 month)
    Number Copies:   1
    Fail on Error:   0
    Residence:       (specific storage unit not required)
    Volume Pool:     Weekly
    Server Group:    (same as specified for policy)
    Residence is Storage Lifecycle Policy:     0
    Daily Windows:
          Saturday   01:00:00  -->  Saturday   07:00:00

any suggestions?

ohad

0 Kudos

rj_nbu
Level 6
Employee Accredited Certified

‎09-13-2009 01:56 AM

Hi

Can you post the logs from the client (sql server):

c:\program files\veritas\netbackup\logs\dbclient\

if this directory doesn't exist on the client, create it and run a backup again



0 Kudos

sumanreddy
Level 4
Certified

‎09-13-2009 03:00 AM

Hi 

check the bacth file (c:\program files \veritas\netbackup\bin\dbext\mssql).

previously i also faced the same issue,
 
if possible create the same batch file using GUI on that client machine and run the backup job.

Regards,
Suman
0 Kudos

O-a
Level 4

‎09-14-2009 01:00 AM

rajeev hi,


like i said the parent steam start to run.but he does not open any child steames and never closed(only if i cancel the job).

i have the dbclient log,it vely long.can i send it  to you by mail?

btw;

i tried to uninstall&reinstall the client but it still does not work.

thanks
0 Kudos

rj_nbu
Level 6
Employee Accredited Certified

‎09-14-2009 01:39 AM

HI

Might be caused due to this:

http://seer.entsupport.symantec.com/docs/315659.htm

Can you also check in the dbclient if there are any errors regarding hostname resolution


0 Kudos

O-a
Level 4

‎09-15-2009 12:22 AM

00:20:03.514 [7908.4268] <2> init_cache: ..\libvlibs\vnet_hosts.c.990: host_cache_size: 200 0x000000c8
00:20:03.514 [7908.4268] <2> init_cache: ..\libvlibs\vnet_hosts.c.991: cache_time: 3600 0x00000e10
00:20:03.514 [7908.4268] <2> init_cache: ..\libvlibs\vnet_hosts.c.1003: host_failed_cache_size: 40 0x00000028
00:20:03.514 [7908.4268] <2> init_cache: ..\libvlibs\vnet_hosts.c.1004: cache_time: 3600 0x00000e10
00:20:03.514 [7908.4268] <2> init_cache: ..\libvlibs\vnet_hosts.c.990: host_cache_size: 200 0x000000c8
00:20:03.514 [7908.4268] <2> init_cache: ..\libvlibs\vnet_hosts.c.991: cache_time: 3600 0x00000e10
00:20:03.514 [7908.4268] <2> init_cache: ..\libvlibs\vnet_hosts.c.1003: host_failed_cache_size: 40 0x00000028
00:20:03.514 [7908.4268] <2> init_cache: ..\libvlibs\vnet_hosts.c.1004: cache_time: 3600 0x00000e10
00:20:03.530 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:03.530 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:03.764 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2904 TO 172.29.1.1.13724
00:20:04.092 [7908.4268] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
00:20:04.092 [7908.4268] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
00:20:04.092 [7908.4268] <4> getServerName: Read server name from nb_master_config: mastersrv
00:20:04.092 [7908.4268] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
00:20:04.170 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:04.217 [7908.4268] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <sqlsrv1\> has been made using standard security with DSN <NBMSSQL_7908_4268>
00:20:04.217 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:04.217 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:04.233 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:04.233 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:04.248 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:04.248 [7908.4268] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <sqlsrv1> on server <sqlsrv1>.
00:20:04.248 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:04.280 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:04.295 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:04.295 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:04.530 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2905 TO 172.29.1.1.13724
00:20:04.998 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:04.998 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:05.186 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2907 TO 172.29.1.1.13724
00:20:05.592 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:05.592 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:05.842 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2910 TO 172.29.1.1.13724
00:20:06.405 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:06.405 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:06.592 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2911 TO 172.29.1.1.13724
00:20:07.030 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:07.030 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:07.264 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2912 TO 172.29.1.1.13724
00:20:07.608 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:07.608 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:07.811 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2913 TO 172.29.1.1.13724
00:20:08.217 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:08.217 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:08.342 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2914 TO 172.29.1.1.13724
00:20:08.717 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:08.717 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:08.795 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2915 TO 172.29.1.1.13724
00:20:09.233 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:09.233 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:09.561 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2916 TO 172.29.1.1.13724
00:20:10.077 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:10.077 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:10.202 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2917 TO 172.29.1.1.13724
00:20:10.733 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:10.733 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:10.967 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2918 TO 172.29.1.1.13724
00:20:11.249 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:11.249 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:11.405 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2919 TO 172.29.1.1.13724
00:20:11.936 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:11.936 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:12.170 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2920 TO 172.29.1.1.13724
00:20:12.561 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:12.561 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:12.842 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2921 TO 172.29.1.1.13724
00:20:13.358 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:13.358 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:13.592 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2922 TO 172.29.1.1.13724
00:20:13.952 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:13.952 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:14.264 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2923 TO 172.29.1.1.13724
00:20:14.764 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:14.780 [7908.4268] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <sqlsrv1\> has been made using standard security with DSN <NBMSSQL_7908_4268>
00:20:14.780 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:14.780 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:14.795 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:14.795 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:14.811 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:14.811 [7908.4268] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <sqlsrv1> on server <sqlsrv1>.
00:20:14.827 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:14.827 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:15.030 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2924 TO 172.29.1.1.13724
00:20:15.577 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:15.577 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:15.889 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2925 TO 172.29.1.1.13724
00:20:16.264 [7908.4268] <4> CDBbackrec::CDBbackrec: INF - Use standard backup method with policy <SQL_Kiron>.
00:20:16.280 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:16.295 [7908.4268] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <sqlsrv1\> has been made using standard security with DSN <NBMSSQL_7908_4268>
00:20:16.295 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:16.295 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:16.311 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:16.311 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:16.327 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:16.327 [7908.4268] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <sqlsrv1> on server <sqlsrv1>.
00:20:16.342 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:16.342 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:16.561 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2926 TO 172.29.1.1.13724
00:20:16.967 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:16.967 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:17.202 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2927 TO 172.29.1.1.13724
00:20:17.358 [7908.7712] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:17.374 [7908.7712] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:17.374 [7908.7712] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:17.389 [7908.7712] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:20:17.389 [7908.7712] <4> Dbbackrec::PerformNBOperation: INF - BACKUP STARTED USING

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)

Nov 24 2008 13:01:59

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup.bch, Op# = 1
00:20:17.389 [7908.7712] <4> InitPipeInfo: INF - Using backup image sqlsrv1.MSSQL7.sqlsrv1.db.db_MSCRM.~.7.001of001.20090915002016..C
00:20:17.389 [7908.7712] <4> Dbbackrec::CreateSQLcmdSyntax: INF - backup database "db_MSCRM" to VIRTUAL_DEVICE='VNBU0-7908-7712-1252966817' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
00:20:17.389 [7908.7712] <4> Dbbackrec::CreateSQLcmdSyntax: INF - Number of stripes: 1, Number of buffers per stripe 2.
00:20:17.389 [7908.7712] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b42340>.
00:20:17.405 [7908.5696] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:17.405 [7908.5696] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:17.405 [7908.7712] <4> CDBbackrec::InitDeviceSet(): INF - Created VDI object for SQL Server instance <sqlsrv1>. Connection timeout is <300> seconds.
00:20:17.530 [7908.5696] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2928 TO 172.29.1.1.13724
00:20:17.749 [7908.4268] <4> CDBbackrec::CDBbackrec: INF - Use standard backup method with policy <SQL_Kiron>.
00:20:17.764 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b43470>.
00:20:17.764 [7908.4268] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <sqlsrv1\> has been made using standard security with DSN <NBMSSQL_7908_4268>
00:20:17.764 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b43470>
00:20:17.764 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b43470>.
00:20:17.780 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b43470>
00:20:17.780 [7908.4268] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b43470>.
00:20:17.780 [7908.4268] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b43470>
00:20:17.780 [7908.4268] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <sqlsrv1> on server <sqlsrv1>.
00:20:17.936 [7908.5696] <4> DBthreads::dbclient: INF - wait for addr assigned 0
00:20:17.952 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:17.952 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:18.092 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2929 TO 172.29.1.1.13724
00:20:18.577 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:18.577 [7908.4268] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:18.749 [7908.4268] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2930 TO 172.29.1.1.13724
00:20:18.858 [7908.8176] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b43470>.
00:20:18.858 [7908.8176] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b43470>
00:20:18.858 [7908.8176] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b43470>.
00:20:18.858 [7908.8176] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b43470>
00:20:18.858 [7908.8176] <4> Dbbackrec::PerformNBOperation: INF - BACKUP STARTED USING

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)

 

Nov 24 2008 13:01:59

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup.bch, Op# = 8
00:20:28.639 [7908.7348] <4> InitPipeInfo: INF - Using backup image sqlsrv1.MSSQL7.sqlsrv1.db.ReportServerTempDB.~.7.001of001.20090915002027..C
00:20:28.639 [7908.7348] <4> Dbbackrec::CreateSQLcmdSyntax: INF - backup database "ReportServerTempDB" to VIRTUAL_DEVICE='VNBU0-7908-7348-1252966828' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
00:20:28.639 [7908.7348] <4> Dbbackrec::CreateSQLcmdSyntax: INF - Number of stripes: 1, Number of buffers per stripe 2.
00:20:28.639 [7908.7348] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7908_4268>, SQL userid <sa> handle <0x00b45d80>.
00:20:28.639 [7908.3628] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:20:28.639 [7908.3628] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:20:28.796 [7908.3628] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2947 TO 172.29.1.1.13724
00:20:29.139 [7908.3628] <4> DBthreads::dbclient: INF - wait for addr assigned 0
00:25:17.411 [7908.7712] <4> getServerName: Read server name from nb_master_config: mastersrv
00:25:17.426 [7908.7712] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:25:17.426 [7908.7712] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:25:17.754 [7908.7712] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2961 TO 172.29.1.1.13724
00:25:18.114 [7908.7712] <4> getServerName: Read server name from nb_master_config: mastersrv
00:25:18.129 [7908.7712] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:25:18.129 [7908.7712] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:25:18.301 [7908.7712] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2962 TO 172.29.1.1.13724
00:25:20.520 [7908.7712] <16> CDBbackrec::InitDeviceSet_Part2(): ERR - Error in GetConfiguration: 0x80770003.
00:25:20.520 [7908.7712] <1> CDBbackrec::InitDeviceSet_Part2():     CONTINUATION: - The api was waiting and the timeout interval had elapsed.
00:25:20.520 [7908.7712] <4> KillAllThreads: INF - Killing group #0
00:25:20.520 [7908.7712] <4> KillAllThreads: INF - Issuing SignalAbort to MS SQL Server VDI
00:25:20.520 [7908.2024] <4> KillAllThreads: INF - Killing group #0
00:25:20.536 [7908.5696] <4> KillAllThreads: INF - Killing group #0
00:25:20.551 [7908.7616] <4> KillAllThreads: INF - Killing group #0
00:25:20.551 [7908.7712] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <9987><[Microsoft][SQL Native Client][SQL Server]The backup of full-text catalog 'ftcat_documentindex_a600a0775fc4dd11bec2001a64998a30' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. >.
00:25:20.551 [7908.7712] <16> CODBCaccess::LogODBCerr: DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]BACKUP DATABASE is terminating abnormally.>
00:25:20.551 [7908.7712] <16> Dbbackrec::PerformNBOperation: ERR - Error found executing <backup database "db_MSCRM" to VIRTUAL_DEVICE='VNBU0-7908-7712-1252966817' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
00:25:20.551 [7908.7712] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00b42340>
00:25:20.551 [7908.7712] <4> getServerName: Read server name from nb_master_config: mastersrv
00:25:20.551 [7908.7712] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
00:25:20.551 [7908.7712] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
00:25:20.708 [7908.7712] <2> logconnections: BPRD CONNECT FROM 172.29.1.24.2965 TO 172.29.1.1.13724
00:25:23.645 [7908.7712] <16> CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->Close: 0x80770004.
00:25:23.645 [7908.7712] <1> CDBbackrec::FreeDeviceSet():     CONTINUATION: - An abort request is preventing anything except termination actions.
00:25:23.645 [7908.7712] <4> Dbbackrec::Perform: INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\backup.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 307(0) seconds.

(this is part of the dblog)

btw
 

and the job is still "runing"

0 Kudos

rj_nbu
Level 6
Employee Accredited Certified

‎09-15-2009 01:08 AM

Open the sql management studio, and check if this database is online and healthy. This should not be a mirrored (TRX log shipping\ Partially Online) or in a suspect state.

this is causing the backup to fail , which netbackup is not able to capture, and job hangs. See this technote also : http://seer.entsupport.symantec.com/docs/315659.htm


Consider applying patch 6.5.4 on your master server and the client



0 Kudos

O-a
Level 4

‎09-15-2009 11:40 PM

how / where can i check if the datebase is mirored and how can chenge it(it s pear db or in the global settings)?
if i install the 6.5.4 it will fix thew problem?
0 Kudos