Thanks all for the replies...

The second server in this case is on an environment that is essentially an exact snapshot of our production environment, which is taken over the weekend. ...

That's what I was thinking, thanks for confirming.

I appreciate all the responses.  Unfortunately, the performance seems to be terrible with a join OR with multiple columns being updated.  The tables we need to update are all very...

True...  I'd just have to make sure I declare my variables after the GO...

I was hoping for a more lazy approach I guess, but I think you're right 😀

We are moving our on-prem instance of Microsoft Dynamics CRM to the cloud version - it's MS so basically Azure.  Our head developer gave me a list of things we...

Thanks for the link, that's very useful information.

Some additional information:  I found a fairly consistent "fix" which was renaming the backup set for each database.

Still not clear on *why* that works, though.

Brian - thanks for the reply...

1. The service account definitely has access; and just to be sure I even tried granting "Everyone" full access to the file and folder, but...

Thanks.

We're being audited and we have to explain to them why any that aren't encrypted; so for example I actually had to provide evidence that you can't do the master,...

Thanks.

One additional question...  if I deny these permissions, is it possible to grant them on specific tables, or does the deny override that?

For example, we have a couple of queue...

Ack, nevermind...  I found the problem...

One of the databases we had to restore after the initial outage was master, and the backup was bad; so it was copied from the...

That makes sense.

One thing I ended up trying since I posted was to decrypting one of the databases.  I was able to use the wizard normally at that point -...

An additional issue...

The restore job on the secondary server is simply skipping over the logs for one of the affected databases.  After completing the wizard, I ran the backup job...

No hard feelings...  been a frustrating week 😀

Thanks for that link; that's a great list.

I guess I could come back with "Looks like you need to learn to read." but that would be rude.

I was not asking about SLEEP_BPOOL_FLUSH - I can find plenty...