Forum Discussion

Ramiro-Magan's avatar
9 years ago

New SQL Backup failing, can´t figure out why.

Hi guys, I am having a bit of a problem with a new sql server. 

I have a domain user that runs the service, that has been configured, it has also been added to the sql securty as db owner, which is what I have configured for all other sql servers.

Yet it will not run.

Part of the error message is related to a odbc invalid connection, but found that the error should be for older versions of sql according to microsoft.

Here is the job detaled status, maybe you can find something I am missing.

 

-------------------------------------

29/02/2016 10:36:11 - Info nbjm(pid=8860) starting backup job (jobid=673818) for client cfhq004vw0244.cfcorp.ad, policy SQL-Full-2weeks, schedule Diario  
29/02/2016 10:36:11 - Info nbjm(pid=8860) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=673818, request id:{058C3EAE-059F-4CB9-A3E1-E5084EE53F52})  
29/02/2016 10:36:11 - requesting resource myarsw00403bk01-hcart-robot-tld-0
29/02/2016 10:36:11 - requesting resource myarsw00403bk01.NBU_CLIENT.MAXJOBS.cfhq004vw0244.cfcorp.ad
29/02/2016 10:36:11 - requesting resource myarsw00403bk01.NBU_POLICY.MAXJOBS.SQL-Full-2weeks
29/02/2016 10:36:11 - granted resource myarsw00403bk01.NBU_CLIENT.MAXJOBS.cfhq004vw0244.cfcorp.ad
29/02/2016 10:36:11 - granted resource myarsw00403bk01.NBU_POLICY.MAXJOBS.SQL-Full-2weeks
29/02/2016 10:36:11 - granted resource myarsw00403bk01-hcart-robot-tld-0
29/02/2016 10:36:11 - estimated 0 Kbytes needed
29/02/2016 10:36:11 - Info nbjm(pid=8860) started backup (backupid=cfhq004vw0244.cfcorp.ad_1456752971) job for client cfhq004vw0244.cfcorp.ad, policy SQL-Full-2weeks, schedule Diario on storage unit myarsw00403bk01-hcart-robot-tld-0
29/02/2016 10:36:11 - started process bpbrm (12268)
29/02/2016 10:36:13 - Info bpbrm(pid=12268) cfhq004vw0244.cfcorp.ad is the host to backup data from     
29/02/2016 10:36:13 - Info bpbrm(pid=12268) reading file list for client        
29/02/2016 10:36:13 - Info bpbrm(pid=12268) starting bphdb on client         
29/02/2016 10:36:13 - connecting
29/02/2016 10:36:13 - connected; connect time: 0:00:00
29/02/2016 10:36:14 - Info bphdb(pid=2188) Backup started           
29/02/2016 10:36:49 - Info dbclient(pid=3056) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.>.
29/02/2016 10:36:49 - Info dbclient(pid=3056) DBMS MSG - SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).>  
29/02/2016 10:37:28 - Info dbclient(pid=3056) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.>.
29/02/2016 10:37:28 - Info dbclient(pid=3056) DBMS MSG - SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).>  
29/02/2016 10:37:30 - Info dbclient(pid=3056) INF - BACKUP STARTED USING        
29/02/2016 10:37:30 - Info dbclient(pid=3056) Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)    
29/02/2016 10:37:30 - Info dbclient(pid=3056) Jun 28 2012 08:36:30         
29/02/2016 10:37:30 - Info dbclient(pid=3056) Copyright (c) Microsoft Corporation         
29/02/2016 10:37:30 - Info dbclient(pid=3056) Express Edition with Advanced Services (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 
29/02/2016 10:37:30 - Info dbclient(pid=3056) Batch = C:\NetBackup SQL Scripts\tlog-2weeks.bch, Op# = 1     
29/02/2016 10:37:30 - Info dbclient(pid=3056) INF - Using backup image CFHQ004vw0244.MSSQL7.CFHQ004VW0244.trx.nDataCordial.~.7.001of001.20160229103716..C       
29/02/2016 10:37:30 - Info dbclient(pid=3056) INF - backup log "nDataCordial" to VIRTUAL_DEVICE='VNBU0-3056-2512-1456753037' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
29/02/2016 10:37:30 - Info dbclient(pid=3056) INF - Number of stripes: 1, Number of buffers per stripe 2. 
29/02/2016 10:37:31 - Info dbclient(pid=3056) ERR - Error in CreateEx: 0x80770007.       
29/02/2016 10:37:31 - Info dbclient(pid=3056)     CONTINUATION: - Failed to recognize the SQL Server instance name.
29/02/2016 10:37:32 - Info dbclient(pid=3056) INF - OPERATION #1 of batch C:\NetBackup SQL Scripts\tlog-2weeks.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(3) seconds.
29/02/2016 10:37:34 - Info dbclient(pid=3056) INF - Results of executing <C:\NetBackup SQL Scripts\tlog-2weeks.bch>:     
29/02/2016 10:37:34 - Info dbclient(pid=3056) <0> operations succeeded. <1> operations failed.       
29/02/2016 10:37:34 - Info dbclient(pid=3056) INF - The following object(s) were not backed up successfully.   
29/02/2016 10:37:34 - Info dbclient(pid=3056) INF - nDataCordial          
29/02/2016 10:37:34 - Error bpbrm(pid=12268) from client cfhq004vw0244.cfcorp.ad: ERR - command failed: none of the requested files were backed up (2)
29/02/2016 10:38:06 - Info dbclient(pid=1240) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.>.
29/02/2016 10:38:07 - Info dbclient(pid=1240) DBMS MSG - SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).>  
29/02/2016 10:38:38 - Info dbclient(pid=1240) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.>.
29/02/2016 10:38:38 - Info dbclient(pid=1240) DBMS MSG - SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).>  
29/02/2016 10:38:40 - Info dbclient(pid=1240) INF - BACKUP STARTED USING        
29/02/2016 10:38:40 - Info dbclient(pid=1240) Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)    
29/02/2016 10:38:40 - Info dbclient(pid=1240) Jun 28 2012 08:36:30         
29/02/2016 10:38:40 - Info dbclient(pid=1240) Copyright (c) Microsoft Corporation         
29/02/2016 10:38:40 - Info dbclient(pid=1240) Express Edition with Advanced Services (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 
29/02/2016 10:38:40 - Info dbclient(pid=1240) Batch = C:\NetBackup SQL Scripts\full-2weeks.bch, Op# = 1     
29/02/2016 10:38:40 - Info dbclient(pid=1240) INF - Using backup image CFHQ004vw0244.MSSQL7.CFHQ004VW0244.db.master.~.7.001of001.20160229103826..C       
29/02/2016 10:38:40 - Info dbclient(pid=1240) INF - backup database "master" to VIRTUAL_DEVICE='VNBU0-1240-3776-1456753107' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
29/02/2016 10:38:41 - Info dbclient(pid=1240) INF - Number of stripes: 1, Number of buffers per stripe 2. 
29/02/2016 10:38:41 - Info dbclient(pid=1240) ERR - Error in CreateEx: 0x80770007.       
29/02/2016 10:38:42 - Info dbclient(pid=1240)     CONTINUATION: - Failed to recognize the SQL Server instance name.
29/02/2016 10:38:42 - Info dbclient(pid=1240) INF - OPERATION #1 of batch C:\NetBackup SQL Scripts\full-2weeks.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(3) seconds.
29/02/2016 10:39:17 - Info dbclient(pid=1240) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.>.
29/02/2016 10:39:17 - Info dbclient(pid=1240) DBMS MSG - SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).>  
29/02/2016 10:39:19 - Info dbclient(pid=1240) INF - BACKUP STARTED USING        
29/02/2016 10:39:19 - Info dbclient(pid=1240) Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)    
29/02/2016 10:39:19 - Info dbclient(pid=1240) Jun 28 2012 08:36:30         
29/02/2016 10:39:19 - Info dbclient(pid=1240) Copyright (c) Microsoft Corporation         
29/02/2016 10:39:19 - Info dbclient(pid=1240) Express Edition with Advanced Services (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 
29/02/2016 10:39:19 - Info dbclient(pid=1240) Batch = C:\NetBackup SQL Scripts\full-2weeks.bch, Op# = 2     
29/02/2016 10:39:19 - Info dbclient(pid=1240) INF - Using backup image CFHQ004vw0244.MSSQL7.CFHQ004VW0244.db.model.~.7.001of001.20160229103904..C       
29/02/2016 10:39:19 - Info dbclient(pid=1240) INF - backup database "model" to VIRTUAL_DEVICE='VNBU0-1240-468-1456753146' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
29/02/2016 10:39:19 - Info dbclient(pid=1240) INF - Number of stripes: 1, Number of buffers per stripe 2. 
29/02/2016 10:39:19 - Info dbclient(pid=1240) ERR - Error in CreateEx: 0x80770007.       
29/02/2016 10:39:19 - Info dbclient(pid=1240)     CONTINUATION: - Failed to recognize the SQL Server instance name.
29/02/2016 10:39:20 - Info dbclient(pid=1240) INF - OPERATION #2 of batch C:\NetBackup SQL Scripts\full-2weeks.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(3) seconds.
29/02/2016 10:39:54 - Info dbclient(pid=1240) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.>.
29/02/2016 10:39:54 - Info dbclient(pid=1240) DBMS MSG - SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).>  
29/02/2016 10:39:55 - Info dbclient(pid=1240) INF - BACKUP STARTED USING        
29/02/2016 10:39:55 - Info dbclient(pid=1240) Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)    
29/02/2016 10:39:55 - Info dbclient(pid=1240) Jun 28 2012 08:36:30         
29/02/2016 10:39:55 - Info dbclient(pid=1240) Copyright (c) Microsoft Corporation         
29/02/2016 10:39:55 - Info dbclient(pid=1240) Express Edition with Advanced Services (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 
29/02/2016 10:39:55 - Info dbclient(pid=1240) Batch = C:\NetBackup SQL Scripts\full-2weeks.bch, Op# = 3     
29/02/2016 10:39:55 - Info dbclient(pid=1240) INF - Using backup image CFHQ004vw0244.MSSQL7.CFHQ004VW0244.db.msdb.~.7.001of001.20160229103941..C       
29/02/2016 10:39:56 - Info dbclient(pid=1240) INF - backup database "msdb" to VIRTUAL_DEVICE='VNBU0-1240-816-1456753182' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
29/02/2016 10:39:56 - Info dbclient(pid=1240) INF - Number of stripes: 1, Number of buffers per stripe 2. 
29/02/2016 10:39:56 - Info dbclient(pid=1240) ERR - Error in CreateEx: 0x80770007.       
29/02/2016 10:39:56 - Info dbclient(pid=1240)     CONTINUATION: - Failed to recognize the SQL Server instance name.
29/02/2016 10:39:56 - Info dbclient(pid=1240) INF - OPERATION #3 of batch C:\NetBackup SQL Scripts\full-2weeks.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 2(2) seconds.
29/02/2016 10:40:31 - Info dbclient(pid=1240) DBMS MSG - ODBC return code <-1>, SQL State <08001>, SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.>.
29/02/2016 10:40:31 - Info dbclient(pid=1240) DBMS MSG - SQL Message <14><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).>  
29/02/2016 10:40:33 - Info dbclient(pid=1240) INF - BACKUP STARTED USING        
29/02/2016 10:40:33 - Info dbclient(pid=1240) Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)    
29/02/2016 10:40:33 - Info dbclient(pid=1240) Jun 28 2012 08:36:30         
29/02/2016 10:40:33 - Info dbclient(pid=1240) Copyright (c) Microsoft Corporation         
29/02/2016 10:40:33 - Info dbclient(pid=1240) Express Edition with Advanced Services (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 
29/02/2016 10:40:33 - Info dbclient(pid=1240) Batch = C:\NetBackup SQL Scripts\full-2weeks.bch, Op# = 4     
29/02/2016 10:40:33 - Info dbclient(pid=1240) INF - Using backup image CFHQ004vw0244.MSSQL7.CFHQ004VW0244.db.nDataCordial.~.7.001of001.20160229104019..C       
29/02/2016 10:40:34 - Info dbclient(pid=1240) INF - backup database "nDataCordial" to VIRTUAL_DEVICE='VNBU0-1240-3192-1456753220' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
29/02/2016 10:40:34 - Info dbclient(pid=1240) INF - Number of stripes: 1, Number of buffers per stripe 2. 
29/02/2016 10:40:34 - Info dbclient(pid=1240) ERR - Error in CreateEx: 0x80770007.       
29/02/2016 10:40:34 - Info dbclient(pid=1240)     CONTINUATION: - Failed to recognize the SQL Server instance name.
29/02/2016 10:40:35 - Info dbclient(pid=1240) INF - OPERATION #4 of batch C:\NetBackup SQL Scripts\full-2weeks.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(3) seconds.
29/02/2016 10:40:37 - Info dbclient(pid=1240) INF - Results of executing <C:\NetBackup SQL Scripts\full-2weeks.bch>:     
29/02/2016 10:40:37 - Info dbclient(pid=1240) <0> operations succeeded. <4> operations failed.       
29/02/2016 10:40:37 - Info dbclient(pid=1240) INF - The following object(s) were not backed up successfully.   
29/02/2016 10:40:37 - Info dbclient(pid=1240) INF - master          
29/02/2016 10:40:37 - Info dbclient(pid=1240) INF - model          
29/02/2016 10:40:37 - Info dbclient(pid=1240) INF - msdb          
29/02/2016 10:40:37 - Info dbclient(pid=1240) INF - nDataCordial          
29/02/2016 10:40:57 - Error bpbrm(pid=12268) from client cfhq004vw0244.cfcorp.ad: ERR - command failed: none of the requested files were backed up (2)
29/02/2016 10:40:57 - Error bpbrm(pid=12268) from client cfhq004vw0244.cfcorp.ad: ERR - bphdb exit status = 2: none of the requested files were backed up
29/02/2016 10:40:57 - Info bphdb(pid=2188) done. status: 2: none of the requested files were backed up  
29/02/2016 10:40:57 - end writing
none of the requested files were backed up (2)

27 Replies