cancel
Showing results for 
Search instead for 
Did you mean: 

"None of the requested files were backed up" MS SQL

Somnia
Level 3

- 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!

1 ACCEPTED SOLUTION

Accepted Solutions

Will_Restore
Level 6

SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE $ALL
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

View solution in original post

11 REPLIES 11

Will_Restore
Level 6

21:02:54.678 [9720.9960] <16> CDBbackmain::OperationsAreGroupable: USER - Verify that an active SQL Server policy exists for this client.
21:02:54.710 [9720.9960] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_9720_9960_3>, SQL userid <admin003@domain1.local> handle <0x013f1590>.
...

21:02:56.178 [9720.9964] <16> CDBbackrec::InitDeviceSet(): ERR - Error in CreateEx: 0x80770007.
21:02:56.178 [9720.9964] <1> CDBbackrec::InitDeviceSet():     CONTINUATION: - Failed to recognize the SQL Server instance name.
...

21:02:59.366 [9720.6224] <16> CDBbackrec::InitDeviceSet(): ERR - Error in CreateEx: 0x80770007.
21:02:59.366 [9720.6224] <1> CDBbackrec::InitDeviceSet():     CONTINUATION: - Failed to recognize the SQL Server instance name.
 

Somnia
Level 3

Well, I've also adjusted the bkup.bch script to backup only one instance rather then $ALL. The result is unfortunately the same.

Something I did notice in the Windows Event logs whenever I kick off the SQL job for this server:

====================================================================

Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date:  31-8-2011
Time:  22:07:24
User:  N/A
Computer: SERVERDB01
Description:
SQLVDI: Loc=IdentifySQLServer. Desc=MSSQLSERVER. ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=7416. Thread=9056. Client. Instance=. VD=.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

=====================================================================

Will_Restore
Level 6

I suggest opening a case with Microsoft

Somnia
Level 3

Well, if someone else can second that suggestion I'm more then willing to take it up with MS tomorrow (as it's almost midnight here).

If anyone else has an other suggestion I'm all ears.....

Somnia
Level 3

Anyone at all?

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

I don't see any NBU error here..... I agree with Bill.

Have you tried to open the NBU for SQL GUI, manually select databases and start backup from there?

Somnia
Level 3

Yes, I did try running it from the NBU SQL Client and the results are pretty much the same. I simply don't understand why I'm still receiving a notification there's no active SQL server policy. This client is in the same SQL policy as the other SQL clients. Re-adding it doesn't solve the problem.

USER - Verify that an active SQL Server policy exists for this client.
ERR - Error in VxBSADeterminePolicy: 26.
    CONTINUATION: - There is no copy of the requested object.
USER - Verify that an active SQL Server policy exists for this client.
ERR - Error in VxBSADeterminePolicy: 26.
    CONTINUATION: - There is no copy of the requested object.
USER - Verify that an active SQL Server policy exists for this client.
ERR - Error in VxBSADeterminePolicy: 26.
    CONTINUATION: - There is no copy of the requested object.
USER - Verify that an active SQL Server policy exists for this client.
ERR - Error in VxBSADeterminePolicy: 26.
    CONTINUATION: - There is no copy of the requested object.
USER - Verify that an active SQL Server policy exists for this client.
ERR - Error in VxBSADeterminePolicy: 26.
    CONTINUATION: - There is no copy of the requested object.
USER - Verify that an active SQL Server policy exists for this client.
ERR - Error in VxBSADeterminePolicy: 26.
    CONTINUATION: - There is no copy of the requested object.
USER - Verify that an active SQL Server policy exists for this client.
ERR - Error in VxBSADeterminePolicy: 26.
    CONTINUATION: - There is no copy of the requested object.
USER - Verify that an active SQL Server policy exists for this client.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\bkup.bch>:
<0> operations succeeded. <7> operations failed.
INF - The following object(s) were not backed up successfully.
INF - WSS
INF - SCOM
INF - master
INF - MMDB
INF - model
INF - msdb
INF - PMDB

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

You need to verify that the master can resolve the request from client's IP address to valid name contained in SQL policy.

See if you have bprd log folder under /usr/openv/netbackup/logs on the master. If not, you will have to create the folder and restart NBU on master. PLEASE use cluster commands to offline and online NBU resource.

After SQL backup attempt is started, you will be able to see incoming request from client's IP address. See if master can resolve to hostname that is the same as client name in policy.

Somnia
Level 3

Indeed, the master could not resolve properly - this has now been fixed and the backups run just fine, thanks!

However, I ran into one small problem afterwards. This SQL system has multiple instances and putting them all together on the same bkup.bch script is causing error code 2. Putting one instance on the script is no problem and is being backed up fine.

Below an example of the script going bad:

OPERATION BACKUP
DATABASE $ALL
SQLHOST "serverdb01"
SQLINSTANCE "CITRIX"
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE $ALL
SQLHOST "serverdb01"
SQLINSTANCE "IIS"
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE $ALL
SQLHOST "serverdb01"
SQLINSTANCE "SCCM"
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE $ALL
SQLHOST "serverdb01"
SQLINSTANCE "WSS3"
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE $ALL
SQLHOST "serverdb01"
SQLINSTANCE "TREND"
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

Removing the blank lines between each operation backup doesn't help and If I change the script to below given example, only the last instance is being backed up. How can this issue be tackled?

OPERATION BACKUP
DATABASE $ALL
SQLHOST "serverdb01"
SQLINSTANCE "CITRIX"
SQLINSTANCE "IIS"
SQLINSTANCE "SCCM"
SQLINSTANCE "WSS3"
SQLINSTANCE "TREND"
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
 

Will_Restore
Level 6

You can use SQLINSTANCE $ALL in your batch file to designate that all SQL Server

instances on your host be backed up. For example, the following batch file backs

up the master, model, and msdb databases. These databases are backed up on all

instances of SQL Server on the host on which the batch file is run.

 

SQLINSTANCE $ALL

OPERATION BACKUP

DATABASE "master"

NBSERVER "BEARING"

MAXTRANSFERSIZE 6

BLOCKSIZE 7

NUMBUFS 2

ENDOPER TRUE

 

OPERATION BACKUP

DATABASE "msdb"

NBSERVER "BEARING"

MAXTRANSFERSIZE 6

BLOCKSIZE 7

NUMBUFS 2

ENDOPER TRUE

 

OPERATION BACKUP

DATABASE "model"

NBSERVER "BEARING"

MAXTRANSFERSIZE 6

BLOCKSIZE 7

NUMBUFS 2

ENDOPER TRUE

Will_Restore
Level 6

SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE $ALL
NBSERVER "SERVERNBUSG01-BCK.DOMAIN1.LOCAL"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE