• I'm cool with anyone handling backups. As long as they get done and (the kicker) as long as we can successfully restore them in a timely manner. If it takes hours to track down a backup (it's happened to me) or I don't have access to the backup software at 3AM (that's happened) or the "backups" work great but the database either won't restore (happened) or restore corrupted (happened), then we are RAPIDLY renegotiating how backups are done (probably following Jeff's model). I don't have a territory to defend. I have processes and protections for the companies information that I have to support. How I do it just doesn't matter. That it gets done is what matters.

    With any 3rd party backup utility (and that includes Red Gate), I would put it through a pretty thorough set of backups and restores, as many scenario's as you've run into recently. Be sure. That's all.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning