How to change the owner of a secondary replica database to ‘sa’
Have you every noticed that when you add a database (where the db owner is ‘sa’) in to a SQL 2012 availability group and synchronise the db to one or more secondary replicas, the database owner at each secondary is no longer ‘sa’ but the name of the account used to add the database into … [Read more…]