Mark Read

ramblings of a sql solution architect

  • About
  • Blog
  • Resources
  • Contact

How to change the owner of a secondary replica database to ‘sa’

May 4, 2014 / Leave a Comment

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…]

Posted in: SQL Server 2016, SQL Server 2014, SQL Server 2012, High Availability, Backup/Restore, AlwaysOn Availability Groups, Security Tagged: how-to
« Previous 1 2

Posts by category

  • AlwaysOn Availability Groups (3)
  • Analytics (2)
  • Backup/Restore (1)
  • Books (1)
  • Business Intelligence (2)
  • Cloud (2)
  • Conferences/Events (2)
  • Data Warehouse (1)
  • Database Mirroring (1)
  • Disaster Recovery (1)
  • Functions (1)
  • High Availability (4)
  • Jobs (1)
  • Machine Learning (2)
  • Musings (3)
  • Patterns and Trends (2)
  • Performance (1)
  • Power BI (1)
  • RPO / RTO (1)
  • Security (2)
  • SQL Server 2012 (3)
  • SQL Server 2014 (3)
  • SQL Server 2016 (5)
  • SQL Server 2019 (1)
  • Storage (3)

Copyright © 2019 Mark Read.