SQL backup of DB in simple recovery mode

[rbkguy]

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

[Will_Restore]

there are a number of restrictions with Simple Recovery Model

please attach output from dbclient log including the time of failure

[Will_Restore]

any luck with this?

[rbkguy · Accepted solution]

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.