How do I find out when a node was added to an availability group? The 2019 Stack Overflow Developer Survey Results Are InReplicate a database to one secondary replica, but not the other secondary replica using Availability Groupadding node to existing availability groupOne Availability group, two primary nodesWindows patching on 3 node Always On Availability GroupIncreasing tempdb data files on 2 node Availability GroupSQL Server 2014: Graceful shutdown of an Availability Group nodeCan't resume synchronization after patch failed on secondary node of Availability GroupSQL Server 2016 Availability Group - 2 Nodes as Primary & Readable Secondary, 1 Node as DRAvailability Group cluster memory issue after network issues. How to dump HADR Log Block Msg Pool?Failure to create availability group

How to create dashed lines/arrows in Illustrator CC

What is the motivation for a law requiring 2 parties to consent for recording a conversation

Does a dangling wire really electrocute me if I'm standing in water?

How to answer pointed "are you quitting" questioning when I don't want them to suspect

Feasability of miniature nuclear reactors for humanoid cyborgs

What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?

Inline version of a function returns different value then non-inline version

Why isn't airport relocation done gradually?

Geography at the pixel level

Can't find the latex code for the ⍎ (down tack jot) symbol

Is it possible for the two major parties in the UK to form a coalition with each other instead of a much smaller party?

Why is the maximum length of openwrt’s root password 8 characters?

What do the Banks children have against barley water?

Carnot-Caratheodory metric

How to manage monthly salary

What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?

How to reverse every other sublist of a list?

Evaluating number of iteration with a certain map with While

What is the best strategy for white in this position?

Could JWST stay at L2 "forever"?

What is this 4-propeller plane?

Is there a name of the flying bionic bird?

JSON.serialize: is it possible to suppress null values of a map?

How are circuits which use complex ICs normally simulated?



How do I find out when a node was added to an availability group?



The 2019 Stack Overflow Developer Survey Results Are InReplicate a database to one secondary replica, but not the other secondary replica using Availability Groupadding node to existing availability groupOne Availability group, two primary nodesWindows patching on 3 node Always On Availability GroupIncreasing tempdb data files on 2 node Availability GroupSQL Server 2014: Graceful shutdown of an Availability Group nodeCan't resume synchronization after patch failed on secondary node of Availability GroupSQL Server 2016 Availability Group - 2 Nodes as Primary & Readable Secondary, 1 Node as DRAvailability Group cluster memory issue after network issues. How to dump HADR Log Block Msg Pool?Failure to create availability group



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








5















Ideally, I am looking for T-SQL that returns two columns: the node name, and the date/time that node was added to the availability group, for all nodes in a given availability group.










share|improve this question




























    5















    Ideally, I am looking for T-SQL that returns two columns: the node name, and the date/time that node was added to the availability group, for all nodes in a given availability group.










    share|improve this question
























      5












      5








      5








      Ideally, I am looking for T-SQL that returns two columns: the node name, and the date/time that node was added to the availability group, for all nodes in a given availability group.










      share|improve this question














      Ideally, I am looking for T-SQL that returns two columns: the node name, and the date/time that node was added to the availability group, for all nodes in a given availability group.







      sql-server availability-groups






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 4 at 13:06









      Mark RaymondMark Raymond

      15614




      15614




















          1 Answer
          1






          active

          oldest

          votes


















          6














          This is as far as I can see not possible with a single T-SQL statement as individual nodes hold only their own create date.



          The sys.availability_replicas page makes reference to a column create_date. This is the datetime value of when the node was added.



          To find the create_date for each replica you would need to first connect that replica and query the table for that instance only as below.



          SELECT [replica_server_name],
          [create_date]
          FROM [master].[sys].[availability_replicas]
          WHERE replica_server_name = @@SERVERNAME





          share|improve this answer























            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "182"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f233950%2fhow-do-i-find-out-when-a-node-was-added-to-an-availability-group%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            6














            This is as far as I can see not possible with a single T-SQL statement as individual nodes hold only their own create date.



            The sys.availability_replicas page makes reference to a column create_date. This is the datetime value of when the node was added.



            To find the create_date for each replica you would need to first connect that replica and query the table for that instance only as below.



            SELECT [replica_server_name],
            [create_date]
            FROM [master].[sys].[availability_replicas]
            WHERE replica_server_name = @@SERVERNAME





            share|improve this answer



























              6














              This is as far as I can see not possible with a single T-SQL statement as individual nodes hold only their own create date.



              The sys.availability_replicas page makes reference to a column create_date. This is the datetime value of when the node was added.



              To find the create_date for each replica you would need to first connect that replica and query the table for that instance only as below.



              SELECT [replica_server_name],
              [create_date]
              FROM [master].[sys].[availability_replicas]
              WHERE replica_server_name = @@SERVERNAME





              share|improve this answer

























                6












                6








                6







                This is as far as I can see not possible with a single T-SQL statement as individual nodes hold only their own create date.



                The sys.availability_replicas page makes reference to a column create_date. This is the datetime value of when the node was added.



                To find the create_date for each replica you would need to first connect that replica and query the table for that instance only as below.



                SELECT [replica_server_name],
                [create_date]
                FROM [master].[sys].[availability_replicas]
                WHERE replica_server_name = @@SERVERNAME





                share|improve this answer













                This is as far as I can see not possible with a single T-SQL statement as individual nodes hold only their own create date.



                The sys.availability_replicas page makes reference to a column create_date. This is the datetime value of when the node was added.



                To find the create_date for each replica you would need to first connect that replica and query the table for that instance only as below.



                SELECT [replica_server_name],
                [create_date]
                FROM [master].[sys].[availability_replicas]
                WHERE replica_server_name = @@SERVERNAME






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Apr 4 at 13:11









                George.PalaciosGeorge.Palacios

                2,526826




                2,526826



























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Database Administrators Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f233950%2fhow-do-i-find-out-when-a-node-was-added-to-an-availability-group%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

                    Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given

                    Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221