You could script it for sure, but i do not. it has not been a problem before and probability of it becoming one is very low. You know your environment...

OK thanks, this is what i was afraid of.
i think we can do fail-over and restore from backup, might be faster.

Here is how we handle this, it may or may not work for you. I think it is not safe to patch both nodes, it defeats the purpose of having...

I understand and agree with the points you made. They were presented to the business unit as a choice between data consistency and availability. Business owners chose availability with eventual...

No, they are mirrored too. Anyway, there is full active-active setup on entire infrastructure, except databases.

GCS - global content switch

Yes it's the same application running east and west, hence talking to the same DBs.

1. correct, no issues. except for network latency resulting from web servers on the east coast have to talk to DB on the west coast.

2. Incorrect. web servers on...

Bump! Anyone? Anybody at all has anything to say about this? Am I on total bleeding edge here?

well, that's just the thing. there is nothing running at these times. This server is hosting 3 SQL instances that have backup jobs at different times, around 9 PM. And...

Bump, anyone? Please....

OK, thanks everyone.

i have no influence over queries that developers write (and already written) and queries that reporting software uses. i have to try speeding things up using what is available to...

Brilliant explanation! Thanks, i suspected that there was something along these lines, having to do with locking. so what you are saying is instead of one publication containing all tables...

well, i wish it was so simple, but the link has nothing to do with it. the problems begin during snapshot creation, well before it starts to apply it to...