Dear folks!
In an AlwaysOn AG I would like to set a database as trustworthy. Here is my approach:
- ALTER DATABASE MyDB SET TRUSTWORTHY ON (NODE A - primary)
- Manual failover to Node B
- ALTER DATABASE MyDB SET TRUSTWORTHY ON (NODE B)
- Manual failover back to Node A
Is there a better/faster way to achieve this?
Thanks!