Forgot to mention that yes, I did try increasing the size of the log file. After that, a shrink will return it to the starting roughly 2gb.

Thank you all for explaining the parts I was missing. I had been very worried that there was something wrong/corrupt with these DB's. Finding out it was more...

Copied what should be the same files from another server, all worked.

Yes, I had misunderstood.

The issue with the Except is that it only exists to handle the rare (relatively) occasion where something went wrong as the process is being...

The date range is a fixed number of months of data (6 months) for all but the first iteration of the loop. That first iteration date wise is much...

The attached show plan statistics outputs gives detailed information on what was being done to process the query (the physical operator. logical operator, argument, objects involved (indexes), row counts, IO...