SQL backup skipping a few databases or failing with none of the requested files were backed up (2) or the backup failed to back up the requested files (6)

Problem

SQL backup skipping a few databases or failing with none of the requested files were backed up (2) or the backup failed to back up the requested files (6)
 

Error Message

04/23/2014 09:30:52 - Info dbclient (pid=4548) DBMS MSG - ODBC return code <-x>, SQL State <37000>, SQL Message <10011><[Microsoft][SQL Native Client][SQL Server]Access denied.>. 
04/23/2014 09:30:52 - Info dbclient (pid=4548) ERR - Error found executing <backup database "_unused--SharedServicesSearch_DB" to VIRTUAL_DEVICE='VNBU0-4548-2412-1398238218' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>. 
04/23/2014 09:30:52 - Info dbclient (pid=4548) ERR - Error in VDS->Close: 0x80770004. 
04/23/2014 09:36:52 - Error bpbrm (pid=28849) from client <servername>:ERR - command failed: none of the requested files were backed up (2) 
04/23/2014 09:36:52 - Error bpbrm (pid=28849) from client <servername>:ERR - bphdb exit status = 2: none of the requested files were backed up 
04/23/2014 09:36:53 - Info bphdb (pid=4456) done. status: 2: none of the requested files were backed up 
04/23/2014 09:30:56 - end writing 
none of the requested files were backed up (2)

INFO ODBC return code <-x>, SQL State <37000>, SQL Message <10011><[Microsoft][SQL Native Client][SQL Server]Access denied.>. 
INFO Error found executing <backup database "_unused--SharedServicesSearch_DB" to VIRTUAL_DEVICE='VNBU0-4548-2412-1398238218' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>. 
ENDOPER TRUE

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

05/06/2014 15:00:37 - Error bptm (pid=17812) media manager terminated by parent process 
05/06/2014 15:00:38 - Info bphdb (pid=2760) done. status: 6: the backup failed to back up the requested files 
the backup failed to back up the requested files (6) 

05/06/2014 14:53:58 - Info dbclient (pid=2760) INF - BACKUP STARTED USING 
05/06/2014 14:53:58 - Info dbclient (pid=2760) Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) 
05/06/2014 14:53:58 - Info dbclient (pid=2760) Nov 24 2008 13:01:59 
05/06/2014 14:53:58 - Info dbclient (pid=2760) Copyright (c) 1988-2005 Microsoft Corporation 
05/06/2014 14:53:58 - Info dbclient (pid=2760) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 
05/06/2014 14:53:58 - Info dbclient (pid=2760) Batch = C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\random.bch, Op# = 1 
05/06/2014 14:53:58 - Info dbclient (pid=2760) INF - Using backup image <server name>.MSSQL7.<server name>.db.Tridion_cm.~.7.001of001.20140506145843..C 
05/06/2014 14:53:58 - Info dbclient (pid=2760) INF - backup database "database name"to VIRTUAL_DEVICE='VNBU0-2760-2708-1399381124' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2 
05/06/2014 14:53:58 - Info dbclient (pid=2760) INF - Number of stripes: 1, Number of buffers per stripe 2. 
05/06/2014 14:53:59 - Info dbclient (pid=2760) INF - Created VDI object for SQL Server instance <<server name>>. Connection timeout is <300> seconds. 
05/06/2014 14:54:22 - Info dbclient (pid=2760) ERR - Error in GetCommand: 0x80770004. 
05/06/2014 14:54:22 - Info dbclient (pid=2760) CONTINUATION: - An abort request is preventing anything except termination actions. 
05/06/2014 14:54:22 - Info dbclient (pid=2760) ERR - Internal error. See the dbclient log for more information. 
05/06/2014 14:54:22 - Info dbclient (pid=2760) ERR - Internal error. See the dbclient log for more information. 
05/06/2014 14:54:22 - Info dbclient (pid=2760) ERR - Error in DBthreads::dbclient: 6. 
05/06/2014 14:54:22 - Info dbclient (pid=2760) CONTINUATION: - The system cannot find the file specified. 
05/06/2014 14:54:22 - Info dbclient (pid=2760) ERR - Error in VxBSAEndData: 6. 
05/06/2014 14:54:22 - Info dbclient (pid=2760) CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid. 
05/06/2014 14:54:24 - Info dbclient (pid=2760) ERR - Error in VDS->Close: 0x80770004. 
05/06/2014 14:54:24 - Info dbclient (pid=2760) CONTINUATION: - An abort request is preventing anything except termination actions. 
05/06/2014 14:54:24 - Info dbclient (pid=2760) INF - OPERATION #1 of batch C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\random.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 27(0) seconds. 
05/06/2014 14:54:26 - Info dbclient (pid=2760) INF - Results of executing <C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\random.bch>: 
05/06/2014 14:54:26 - Info dbclient (pid=2760) <0> operations succeeded. <1> operations failed. 
 

Cause

Database name contains Hyphen  '--' 

Solution

Database which were getting skipped or failed had '--' hyphen in database name like __unused--databasename_DB.

It's not possible to make a modification to the NetBackup backup script to skip '--'.

Rename the database (omitting the hyphen) and the backup will succeed.