Nick, it really would depend on your backup strategy and rotation, and a little understanding of relational databases helps here too.
Maintenance, whether it be SQL or ARCserve's own database will only trim what has passed the prune retention time (by default 30 days), but the prune job doesn't...