SQL 2019 Availability Group for master?

%3CLINGO-SUB%20id%3D%22lingo-sub-1046509%22%20slang%3D%22en-US%22%3ESQL%202019%20Availability%20Group%20for%20master%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1046509%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20earlier%20announcements%20of%20SQL%20Server%202019%20a%20new%20feature%20was%20mentioned%20that%20allows%20to%20replicate%20system%20databases%20in%20an%20Availiability%20Group.%20Unfortunately%20I%20cannot%20find%20any%20further%20information%20-%20did%20this%20feature%20make%20it%20to%20the%20final%20product%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fredmondmag.com%2Farticles%2F2018%2F12%2F03%2Fsql-server-2019-at-pass-summit.aspx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fredmondmag.com%2Farticles%2F2018%2F12%2F03%2Fsql-server-2019-at-pass-summit.aspx%3C%2FA%3E%3C%2FP%3E%3CP%3EHere%20it%20says%3A%26nbsp%3B%3CSPAN%3EIn%20SQL%20Server%202019%2C%20Microsoft%20is%20correcting%20this%20by%20addressing%20both%20Master%20and%20MSDB%2C%20which%20will%20simplify%20the%20administration%20of%20availability%20groups.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20ideas%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%20-tom%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1124930%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%202019%20Availability%20Group%20for%20master%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1124930%22%20slang%3D%22en-US%22%3EI%20too%20have%20this%20question.%20According%20to%20the%20docs%20at%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Favailability-groups%2Fwindows%2Fprereqs-restrictions-recommendations-always-on-availability%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Favailability-groups%2Fwindows%2Fprereqs-restrictions-recommendations-always-on-availability%3Fview%3Dsql-server-ver15%3C%2FA%3E%20%2C%20if%20you%20search%20for%20%22system%20databases%22%20the%20first%20item%20under%20checklist%3A%20requirements%20says...%20%22Be%20a%20user%20database.%20System%20databases%20cannot%20belong%20to%20an%20availability%20group.%22%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20which%20is%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1125066%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%202019%20Availability%20Group%20for%20master%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1125066%22%20slang%3D%22en-US%22%3EI%20decided%20to%20contact%20the%20author%20of%20the%20magazine%20article%20and%20got%20a%20quick%20response.%20That%20feature%20had%20some%20challenges%20and%20did%20not%20make%20it%20into%20GA.%20He%20expects%20it%20in%20a%20CU%20at%20some%20point%2C%20but%20cannot%20say%20when.%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20it%20appears%20we%20will%20have%20to%20wait%20a%20while%20longer.%20It%20would%20surely%20be%20a%20good%20reason%20for%20us%20to%20upgrade%20from%202017%20right%20away%20instead%20of%20waiting.%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

In earlier announcements of SQL Server 2019 a new feature was mentioned that allows to replicate system databases in an Availiability Group. Unfortunately I cannot find any further information - did this feature make it to the final product?

 

Example: https://redmondmag.com/articles/2018/12/03/sql-server-2019-at-pass-summit.aspx

Here it says: In SQL Server 2019, Microsoft is correcting this by addressing both Master and MSDB, which will simplify the administration of availability groups.

 

Any ideas?

Regards -tom

 

2 Replies
Highlighted
I too have this question. According to the docs at https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restriction... , if you search for "system databases" the first item under checklist: requirements says... "Be a user database. System databases cannot belong to an availability group."

So which is it?
Highlighted
I decided to contact the author of the magazine article and got a quick response. That feature had some challenges and did not make it into GA. He expects it in a CU at some point, but cannot say when.

So it appears we will have to wait a while longer. It would surely be a good reason for us to upgrade from 2017 right away instead of waiting.