"None of the requested files were backed up" MS SQL
- Netbackup 7.0.1 running on clustered RedHat Enterprise Linux (2 nodes).
- Two media servers (Windows 2008 R2)
- One SQL 2005 Server Enterprise client running on Windows 2008 SP2 (32bit) - this is a stand-alone system, not is clustered.
- One SQL 2005 Server Enterprise client running on Windows 2003 R2 SP2 (32bit) - this is a stand-alone system, not clustered.
I've no problems whatsoever backing up the the SQL DB's on the Windows 2008 system, but for some reason I end up with error code 2 ("None of the requested files were backed up") on the SQL DBs on Windows 2003.
I've tried to use the local System account, set the local Administrator account to run on the NetBackup Client Service, tried my personal Domain Admin account to run on the NetBackup Client Service and even the SQL SA account.....but keep receiving above error message.
- None of our SQL systems are installed on a domain controller.
- All of our SQL systems are within the same NetBackup SQL policy
- The Backup Selection path is valid on all systems ... C:\Program Files\Veritas\NetBackup\DbExt\MsSql\bkup.bch
The bkup.bch script looks like follows:
OPERATION BACKUP
DATABASE $ALL
SQLHOST "serverdb01"
NBSERVER "NBUSERVERSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
I've attached the latest dbclient log file.
Would appreciate if anyone can assist or give pointers to where to look to correct the problem.
Thanks!
SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE $ALL
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE