This will give you a list of local databases that are not in an AG, or where the local server is the AG primary...

select name from sys.databases where database_id not...

Your change would actually show up as I (an insert).

Let's say that you have a a record and it gets inserted and updated a couple of times, I'll include the...

13.0.1500.327

Question is why would you cluster on virtual hardware? (other than for cheap QA & validation)

I'm interested to know what this is providing you.

Probably a silly question, why was the database in full recovery in the first place if you aren't worried about recoverability? And why shrink the log so? It will just...

Out of curiosity, are your SQL and SQL Agent services using the same account?

The server proxy? You don't, any time xp_cmdshell would get called by the proc it would launch as that particular user specified (rather than the service account)

One other thing, I just remembered, you could also enable a server proxy account. By doing this any execution of xp_cmdshell would run under that proxy. It might be worth...

What authentication are you using for the linked server security?

Could you script it out and paste that?

That's a little surprising, I would expect a stored proc call to xp_cmdshell which launched DTEXEC to actually use the SQL Service account, not the Agent account.

Either way, your best...

You might want to check that your servers can communicate over that port and aren't being blocked by a firewall. Telnet is great for doing that.

Make sure that you grab the most recent restore records from that query first. If indeed they are showing that the most recent file has nothing to restore then confirm...

Have you looked for errors on the log shipping monitor or secondary server?

SELECT TOP 1000 [agent_id]

,[agent_type]

,[session_id]

...

Wow, that's a whole lot of stuff. Why not just replicate to two different table names and then union all the results together in a view for querying?

The article is good but it needs to address the flaws of attempting to do this, for example how threading index rebuilds or stats rebuilds could seriously impact the i/o...