• I like the idea of putting something like this as a task in a plan. This is dynamic in that it gets new databases without me having to do anything.

    I add the "COPY_OnlY" parameter so that my backups don't interfer with other running plans. Then I include the databases excluded in this example (except tempdb). That way I have my system db backups as part of the same thing. Better to have it and not need it than to need it and not have it.

    Great script. It's simple and easy to understand. Thanks.

    ATBCharles Kincaid