Object locking with availability groups

brianmullins

Good morning,

Can SSC4's object locking be used with availability groups? Would I need a Redgate database for each availability group, or can it work with a single Redgate DB?

Thanks,

Brian

Sergio R

Hi,

That's not a scenario that we have tested since SQL Source Control tends to be used in development environments.
In that case ideally all source controlled databases should be in the same AG as you can only have 1 Redgate DB.
Bear in mind that object locking also uses a DDL trigger.

http://documentation.red-gate.com/displ ... ct+locking

Thank you,