Configuring Replication with Availability Groups
Configure SQL Server replication with availability groups and understand its supported publisher and subscriber roles.
Continue readingBrowse the archive
Availability Groups
SQL Server FCI won't start after OS Upgrade
Question I have a two node sql server 2008 r2 cluster that we just did an OS upgrade from windows 2008 r2 to windows 2012 r2, the OS upgrade was done in place so the SQL Server Installation stayed in tack. The cluster role won't come back online saying it's …
Continue readingSpread workload with always on high availability groups
Question I am wondering if it is possible to split up a very large query to have parts of it done on the secondary read only servers, or If this feature only allows me to run separate queries or scripts on the secondary servers. I would also like to know if …
Continue readingTransaction Replication on AlwaysOn
Question In our AlwayOn environment I have two SQL servers 2014 Ent.edition (SERVER A, and SERVER B). I setup a transaction replication for [database A ], pointing to listener which shouldn't cause any issue if a failover happened. Tested, worked just fine …
Continue readingWhen setting up an AlwaysOn Availability Group, should the master database be one of the "Availability Databases"?
Question I just got a Sql Server 2016 Availability Group setup (A Primary, a Syncronous Secondary and a Async Secondary). I have five databases on the servers. I setup an application to run queries against the server (using Entity Framework with a "failover …
Continue readingRisks of manual failover in Always On Availability Groups
Question In my environment, I have SQL 2014 with Always On Availability Group for databases in asynchronous with manual fail over. We have 1 primary and 2 secondary replicas--secondary1 and sec2. I have to do failover from primary to secondary1. I know some …
Continue readingAlwaysON Migrate from 2014 to 2016
Question I have like 20 Listners on 2014 with approx 500 DBS, what is the best way to migrate these with least downtime, effort My idea is: Stop access Backup dbs Start restore dbs While restore is running: Drop AOG on 2014 Create it on 2016 Done
Continue reading
Podcast: Mirroring, Availability Groups, Replication, and Log shipping
Have you ever wondered what the best option is for making your data available in your environment? I was asked by Carlos L Chacon (blog|twitter) to be part of a panel on his podcast for an episode discussing some of the options–availability groups, mirroring, …
Continue readingWhat is the benefit of having multiple databases in the same Availability Group vs single AG per database
Question We are planning a migration from current mirroring architecture to Availability Groups for several databases. For every Database we have defined the primary/secondary replica configuration. The question that I'm unsure is: do we need to group the …
Continue readingReportServerTempDB in AlwaysOn Availability group
Question ReportserverTempdb logfile is 6TB in size and growing and I need help. I am supporting a huge reporting server farm and the client wants reporting services to be in AlawysON Availability group(AAG) and we configured reportserver and …
Continue reading