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.