Job Completed with Exceptions in BE2012

[William_Lawance]

Hi,

This exception encountered start from past few days. I have disabled snapshot technology in AOFO.

Attached capture for reference.

Please help.

Thanks

[pkh]

To get rid of the problem, you need to do a transaction log backup.  See my article below

https://www-secure.symantec.com/connect/articles/how-backup-sql-logs-and-truncate-them-be-2012

You need to have at least 2 jobs for your server.  One job with AOF on to backup your files and another with AOF off to backup SQL databases only.  For the second job, you can then define a log backup job.

[William_Lawance]

Since SDR is using, will separate backup job (for server data / system state & for SQL DB / log) affected ?

[pkh]

No.  You can check by seeing that the SDR light is on when you do your selection for the file backup.

[VJware]

Had already posted over here regarding the transaction log backup - https://www-secure.symantec.com/connect/forums/backup-exec-will-not-follow-mount-point

[William_Lawance]

- This means I should creatre 2 jobs. One for whole server data (SDR) and one for DB ?

- Otherwise, I want FULL daily backup for SQL. Is possible ? How to set it ?

[William_Lawance]

What's the different of using this method (sql db only) and full backup of everyething (data + sql db) ?

Thanks

[pkh]

If you combine your file backup with your SQL backup, how are you going to define your log backup? Remember there is only one selection list

[William_Lawance]

If SDR (without SQL) and SQL backup are separated, then how SDR process ?

Restore OS / Data / System state with SDR, then restore SDR in recoved Windows OS ?

Thanks

[pkh · Accepted solution]

Yes. You restore the SQL data after the server is recovered by SDR.

[William_Lawance]

I also backup SQL with same method.

But why only this server have transcention log problem ?

Thanks

[pkh]

...  because you are maintaining transaction logs.

Do search the Web to read more about SQL transaction logs.