I think it involves removing the database from the availability group before restoring and adding it back in afterwards.  As for the exact process, I'd have to do a search...

Can we see your function, please?

John

Check out the documentation for the CONVERT function.  The third argument has to be an integer, so ' ' is invalid.

John

Changing those three CASE expressions so they say sum(T5.TaxSum/T0.DocRate) should resolve the error.  Whether it actually gives the results you're looking for - well, that's something you'll want to check...

The only thing I can think of, in that case, is that you have things in your HAVING clause that ought to be in a WHERE clause.

SELECT
TicketDate
,TicketNum
,ploadDate
,Amount
,Name
,DOB...

That may work, although by the time you know it's happening, you may have missed a lot of the interesting stuff.  That's why I suggested querying the plan cache now. ...

So the code you posted isn't the code that's in your job step?  Please will you post the (whole) code that's giving the error?

John

You need to take the double quotes out of the first query - since the query itself is not enclosed in quotes, they only need to be single.

John

Does domain\agentfromserver1 have a login on Server2, or is it a member of a group that does?

John

You've put this in a job step, right?  Please will you post the whole code from the job step?  I suspect that what you've posted is only a snippet, since...

You don't have to wait until next time it happens - it's worth running it now since the queries may still be in memory, provided you don't have a small...

First of all, are you sure that it's SQL Server, not some other application or service, that is spiking?  If you are, tweak the query in this post and...

All you've done is change TRUNCATE to DELETE, right?  That's going to run slower and use more log space, and mean you have to do the extra step of reseeding...

I don't think there is.  Think about what it would mean: you have three AGs all running on the same node, all with the same listener, which points to that...

I haven't used Availability Groups in Standard Edition, but the documentation clearly states you can only have a single database in an AG.  There may be some coding you...