I think the focus should be database centric because filegroups are database centric. Rather than arbitrary unique names across database, have a set of standard names to use in...

Are you checking the last_execution_time? Running a filtered trace will either confirm an issue or help identify how the procedure is being run.

Thanks for the responses. I'll ask operations to make insure 'Application Aware Image Processing' and 'Do not truncate' are selected. Are the strategies below valid? Are there...

BTW, a zero downtime application would be hard to design. You probably need to nail down the requirements to get at what the client needs rather than wants. ...

A magic merge? Perhaps an SSIS package to migrate last minute data? If only some activities cause issues and are okay to disable a short time, that would...

Thanks. We have a job to back up the transaction logs, so truncating them is probably not the option for us. Is this option only for SQL Servers...

That would explain it. The agent job information cached has to be refreshed. This is not done when using system tables directly. In addition, the supported methods...

I would have thought that the option specify an escape character or a literal string would have been added years ago. I guess it's not that important in the...

This might be fun to try. The number of quotes required is exponential with the nesting level. I used spaces, not tabs, in some places to help format...

One thing that I find interesting is that the escape character can be specified with a LIKE. I don't see why the same syntax could not apply to a...

I had also had this issue today on a test server (e.g., desktop). I've been defecting and re-mastering a lot. I changed my service account today as well...

After all that, I am wondering if perhaps I can't just change the bit on the target schedule, edit the schedule, and then change the bit back.

Thanks for all the advice. I'm still trying to figure out the "best" way to go. I'm also considering creating a group of "identical" master jobs that very...

If I either remove the target or delete the master job, the job on the target gets removed - as it should. I'm curious - is it possible to...

I was thinking of a waitfor, but that would make the run time information harder to use. I want to know how long the backup takes, for example. ...