SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


By Kenneth Fisher,


Enjoy our latest crossword puzzle and see if you can solve all the clues. The theme for this crossword is high availability. The key will be posted in the comments tomorrow.


4. Same piece of data was updated in two different locations.

5. Instance that keeps an eye on articles for changes.

7. Backup log, copy log, restore log.

12. A set of databases that fail over together.

17. Can be an initial copy of the data.

18. Copy of the whole database, but no, it's not backward.

20. Where the data is written to. AG

21. Receives data. Can be a push or a pull.

23. Potential failover target.

24. More than one writeable location.


1. Always points to the primary replica.

2. Edition required for Availability Groups.

3. Manage these separately if you want your batch process to work after a failover.

6. Manage these separately if you want to be able to log in after a failover.

8. A group of Articles.

9. Commit now, sync later (hopefully).

10. Switch over to a secondary.

11. Instance that receives the data.

13. Marketing term that covers Availability Groups and Failover Cluster Instances

14. Notifies the subscriber of changes.

15. Instance required for automatic failover in mirroring.

16. Copy

17. No commit until the secondaries are set.

19. Allowable data loss after a disaster. abbr.

22. Secondary that can be used for backups or reporting.

Total article views: 109 | Views in the last 30 days: 1
Related Articles

Combining AlwaysOn Groups With Failover Cluster Instances

This article discusses failover cluster instances and AlwaysOn groups


Sudden Differential Backup Failures after an Availability Group Failover

As so many stories do, this story starts with a failover - in this case an Availability Group (AG) f...


Grouped Failover, a 2008R2 version of Availability Groups

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being...


‘Object Reference Not Set to an Instance of an Object’ When Failing Over an Availability Group Using SSMS

Here’s a quickie that I’ve just stumbled across. I’ve just tried to initiate a manual failover of...


Availability Groups - Where Did My Disks Go?

The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage! --At a ...

high availability (ha)