• Wayne,

    Check out Tara Kizer's stored proc here. It's proven quite useful for me. Backing up User databases backs up all non-system (and non-primary log-shipping) databases.

    Dustin Mueller
    @sqlcheesecake