• Thanks for getting back to timely with the solution -

    Since we are talking about next version things, I had to make one other modification to not backup snapshots:

    in the DATABASESELECT, I had to add to the "insert into @database02..." the following:

    INSERT INTO @Database02 (DatabaseName, DatabaseStatus)

    SELECT [name], 1

    FROM sys.databases

    WHERE database_id > 4

    AND source_database_id IS NULL

    I had thought about doing the "-DB" part, but I wanted this to be as "set it and forget it" as possible...if a DB was set to simple, it just doesnt do the backup, and vice versa. THANKS!

    -- Cory