Hi Guys,
thanks for replying.
Ok, the backup does not fail with any error messages, what happens is that the backup hangs and when i come in the morning i find that the job is still running.
The policy that is scheduled to run everyday include FULL back ups of two databases, one is for the live production database and the second one is a backup of the training database.
What tends to happen is that, after the live backup has complted, when it comes to backing up the training database, it hangs all night long. In the end, i am having to cancel the job.