Y unsolved mysteries like that can be annoying, but pick your battles. If it's not causing any problems then let it go.

Did you failover to the 2ndary before removing the primary?

You know, you didn't have to remove the primary. Why didn't you just backup the log on the primary and...

Ok, 2 things:

1. Don't just check the frag on the one heap cause if you read above he said that it frags all indexes. Or it can anyway. ...

I don't like supporting these daisy chaining scenarios but I agree, it should work just fine.

I don't consider it good repl design though because if something happens to the 1st...

Try using an alias and then pointing the monitor at the alias.

There is a tried and true method for disabling a win group in sql. Now don't tell anyone, cause this is a secret I've kept close for a long...

@jack-2... was it using an AD acct? Cause I've seen that before where the windows layer flakes out from time to time and isn't able to authenticate properly. ...

Basically a lock keeps someone from changing the data while you're accessing it, and a latch keeps someone from changing the col itself while you're accessing it.

So it keeps someone...

Well then, if there are no other problems with SQL and you can't find anything online about it then I'd say you can ignore it until it becomes an issue.

How...

Snapshot your VMs before doing anything like this.

I think you guys have all been punked.

Agreed. Images don't compress. But it depends how much of the DB they make up. But I've all DBs that were pretty much just image repositories and...

Have you checked that you don't have any maint plans or SSIS pkgs that may be calling it?

Y BOL is great. Denny's book doesn't really cover stuff like that. He's more concerned with the overall security of your enterprise. Excellent info, but not at...

I would also check that these are on the same network segment. Maybe the router in front of these boxes is overloaded, or has something else slowing down the...