Options
Object locking with availability groups
brianmullins
Posts: 2
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
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
Comments
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,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools