I've tried creating the jobs and schedules in different orders and the full appears to run first in my testing. I just wasn't sure if this was a documented thing....

Yes you are correct. The files themselves are very different which is why I wasn't able to make them more generic.

So for instance I may have a package that...

Thanks for the replies. Yes the money is very real. The reason it is so serious is because they only keep a couple weeks worth of backups which have never...

I never did figure out why this was happening. It went away on its own and did not occur again.

I just recently acquired a server and while documenting it I noticed it hasn't completed a transaction log backup in weeks due to disk space. The chain was not broken....

It is a standalone server. No failover.

The only 2 jobs that have failed are tranlog backup and full back. Reindex, statistics, and integrity check all ran without errors. The tranlog backup has only failed once in...

It should use part number if you search for part number alone. I'm not sure about the rest. You could test by viewing the execution plans to be certain.

No recent changes by myself or server team.

I'm not sure what the original intent was as I didn't create it. Thanks everyone for the suggestions.

Lowell (2/18/2014)

---

use the metadata to build a query;

probably featuring a UNION ALL if you want them in a single resutl set

SELECT

'SELECT ' + schema_name(schema_id)+ ' AS SchemaName,* FROM...

Thanks for all of the responses. I have determined what was causing the growth which was caused by an application that was having issues.

24GB free now.

63GB is the size.

Maintenance jobs run late Saturday / early Sunday. The alert was not triggered Sunday after these ran.

I don't have monitoring in place to trap...