Having your code would be good here. If it isn't consistently backing up data (it sounds like it does back up the databases, but not on a regular basis), my inclination is first that something might be wrong in the code. Is it a stored procedure backing up the databases?
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455