Timeline for SQL Server Availability Group does not update DB owner automatically
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 14 at 23:38 | comment | added | variable | @Shanky - In latest SQL versions, does the primary db owner change doesn't reflect in secondary db? | |
| Nov 16, 2016 at 5:15 | vote | accept | Peter PitLock | ||
| Nov 15, 2016 at 22:11 | history | edited | Daniel Hutmacher | CC BY-SA 3.0 |
Clarification: active/passive node -> primary/secondary replica
|
| Nov 15, 2016 at 14:57 | comment | added | Shanky | Can you show me where it says it is a good security practice. | |
| Nov 15, 2016 at 14:35 | comment | added | Nic | @Shanky how is having the database owner be SA not a good security practice? | |
| Nov 15, 2016 at 12:15 | comment | added | Shanky | If you really want owner as SA you can do it but that is not a good security practice, moreover this will again require a failover. So if you have to do failover why not go with owner you want to keep instead of SA | |
| Nov 15, 2016 at 12:13 | comment | added | Peter PitLock | Thank you Shanky - do you agree with the comment by Smairo where i should set the owners to 'sa' at intervals? | |
| Nov 15, 2016 at 12:11 | comment | added | Shanky | If you dont want to do failover you can take database out of AOAG and then configure again with correct DB owner. I also see your method is correct one, I dont see any issue with limited things we have got | |
| Nov 15, 2016 at 12:07 | comment | added | Peter PitLock | It is a 3GB database at this stage but is growing rapidly - would there be an advantage / other option depending on size of db? | |
| Nov 15, 2016 at 11:50 | comment | added | Shanky | How big is your database which participates in availability group ?. Yes this is a limitation which, I am not aware whether is fixed in SQL Server 2016 or not. | |
| Nov 15, 2016 at 10:23 | answer | added | user62379 | timeline score: 2 | |
| Nov 15, 2016 at 10:10 | history | asked | Peter PitLock | CC BY-SA 3.0 |