Thanks Sean !

How would the hacker pass that variable to the stored procedure ? If it's part of a form on a website, then hackers can enter character strings. But...

Could someone include the "how" and "why" that dynamic SQL is vulnerable to SQL injection ?

Yes, that is what I did too.

set @CMD = 'copy...

It might not be a "normal" size for that database if it grew large due to a lack of t-log backups some time in the past. But now that you...

Why are you running code from files, instead of having the code in stored procedures, then executing the stored procedures. Is there an advantage to files ?

You can increase the history for future job runs.

Maybe if you restored MSDB backups to a temporary database you could query the job history tables. They may still have older...

Wouldn't the LEFT OUTER JOIN only work for new records, not changed records ?

I was also thinking replication would work.

Do you mean .MDF file ?

There are many ways it could be processed & scheduled. Have you looked at the SQL scheduled jobs ?

What is done with the file ?...

Rather than dig up an old thread to post a different question, I think you'd be better served by starting a new thread.

These bugs have been around for a long time. They must be very low on the priority list.

My snippet is not very clear.

Job_Date is a DATETIME column in the table, and it's also getting named as a field as a result of the convert. So...

Same problem here too. Sometimes it changes to 24 minutes, so I have to change it a 2nd time to get it to "stick".

I suppose you could set up...

Yes, removing the alias works, but it seems strange that it is not valid code. Upgrade Advisor won't work because we have Cold Fusion and PHP code outside of SQL.

You could contact the backup software company. Perhaps they have "retry" settings that will help if there is contention or network problems.