Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

SQL Backup missing DBs

Created: 09 Sep 2012 • Updated: 21 May 2013 | 2 comments
syedzeeshan's picture
This issue has been solved. See solution.

hi ,

hi i was taking script based backup 6.5.5 using te ebb file due to $ALL and

due to the fact just 1 db size 800GB

 

Since i upgrade on 7.5 nbu master nd client

i backups are not running accordingly .

 

normal script

 

OPERATION BACKUP
DATABASE $ALL
SQLHOST "HO2VATRANVS"
SQLINSTANCE "HO2VATRAN"
NBSERVER "HOBAK1"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY Ho2vatran_SQL_Full_Policy
BROWSECLIENT "HO2VATRANVS"
NUMBUFS 2
ENDOPER TRUE
 

 

cleint buffer size 256

client timeout 20000

 

aonther fast script

 

OPERATION BACKUP
DATABASE $ALL
SQLHOST "HO2VATRANVS"
SQLINSTANCE "HO2VATRAN"
NBSERVER "HOBAK1"
STRIPES 03
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY Ho2vatran_SQL_Full_Policy
BROWSECLIENT "HO2VATRANVS"
NUMBUFS 2
ENDOPER TRUE

 

 

cleint buffer size 256

client timeout 20000

 

 

 

i am attaching bphdb logs

among 10 db only 4 dbs backed up with status 1

however businees critical 800gb is not backup up

 

please advice

 

 

 

 

Comments 2 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

Please post following logs

  • output of "bppllist Ho2vatran_SQL_VITAL_Policy -U" and "bppllist Ho2vatran_SQL_Full_Policy -U"
  • job details of failed jobs
  • dbclients logs

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Marianne's picture

Check NetBackup Client Service on SQL client - was probably reset to LocalSystem during upgrade.

Change to same logon account as SQL services.

If that does not fix your problem, please post dbclient log.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION