Video Screencast Help

sql 2008 backup on netbackup 7.0

Created: 17 Jun 2010 | 3 comments
ayodeji's picture

Hi All.

i need a sample script to backup sql server 2008 on NBU 7.0. i pointed the backup selection of the sql policy  to the script below, but it gave error 2: none of the requested files were backed up.

can you assist please.

OPERATION BACKUP
DATABASE $ALL
SQLHOST "bankeye"
NBSERVER "SV001VMS01"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
ENDOPER TRUE

Comments 3 CommentsJump to latest comment

Marianne's picture

Sample script looks fine.
Ensure master server can resolve client's IP address to same hostname used in script and policy.
Please post dbclient log file on SQL client.

*** EDIT ****
You might have to add the Instance.
You can also use the User interface on the SQL client to create scrips.
Info as well as sample scripts in the NBU for SQL Admin Guide.

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

ayodeji's picture

the master server can resolve the name and the IP.

Ayodeji Oni
NetApp/VERITAS/IBM/SCS

Marianne's picture

PLEASE POST CLIENT DBCLIENT LOG FILE.

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