Video Screencast Help

SQL backup of DB in simple recovery mode

Created: 23 Jun 2012 • Updated: 18 Jul 2012 | 3 comments
This issue has been solved. See solution.

Hi everyone!

 

I am running Netbackup 7.5 on Windows 2008 and I running into issues backing up databases in simple recovery mode. The backups complete for all the DBs in full recovery mode and the job exits with status (1). Do you need to a different scripts to backup DBs that are in simple mode?

 

 

INF - The following object(s) were not backed up successfully.
INF - PortalPilot_Profilele

 

 

OPERATION BACKUP
DATABASE "PortalPilot_Profile"
SQLHOST "XXXX-PPROD-APP1"
NBSERVER "XXXX-BK-HQ1"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

Comments 3 CommentsJump to latest comment

Will Restore's picture

there are a number of restrictions with Simple Recovery Model

please attach output from dbclient log including the time of failure

Will Restore -- where there is a Will there is a way

Will Restore's picture

any luck with this?

Will Restore -- where there is a Will there is a way

rbkguy's picture

I do believe this is an issue with SQL and not netbackup. I have asked out DB admin to have a look as SQL is not able to do a dump of the DB either.

SOLUTION