In an AlwaysOn AG I would like to set a database as trustworthy. Here is my approach:
Is there a better/faster way to achieve this?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by ThomasRushton · Jun 06, 2019 at 12:10 PM
I've not had much luck doing that recently, and have always ended up taking the DB out of the AG, making it trustworthy, and then re-adding it to the AG
Yeah, but if I remove the (primary) DB from the AG, the secondary DB will be in restoring mode. And I won't be able to alter it...
Oh, I think I get your point. So the steps would be like following:
Answers Answers and Comments
17 People are following this question.
SQL Server Memory usage during Availability Group Failover
Automating Availability group patching
Multi Subnet Availability Group Listener not switching to DR IP
Verifying that full and log backups have taken place in a availablity group
SQL2008 Linked Server and SQL2012 AG issue.