How can we help you today? How can we help you today?

Object locking with availability groups

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
brianmullins
0

Comments

1 comment

Sort by
  • 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,
    Sergio R
    0

Add comment

Please sign in to leave a comment.