How to Create SQL 2019 Always ON High Availability

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ม.ค. 2025

ความคิดเห็น • 69

  • @muneerqureshi4662
    @muneerqureshi4662 ปีที่แล้ว +1

    Very nice۔۔۔informative ۔❤❤❤

  • @kk_land4403
    @kk_land4403 2 ปีที่แล้ว

    Required to setup a SCCM Always available group DB. Watched this and completed in no time. Great.

  • @dmuthami
    @dmuthami ปีที่แล้ว

    That was an epic tutorial. Imagine i tried it using Windows Server 2022 and SQLServer 2022 and was successful.

  • @hassanhanfi2829
    @hassanhanfi2829 ปีที่แล้ว

    Great teacher my mentor. ❤

  • @reeva3693
    @reeva3693 3 ปีที่แล้ว +1

    Short-Simple and awesome... Keep it up!!!

  • @arashhoseinkhani
    @arashhoseinkhani 3 ปีที่แล้ว +1

    Excellent MR Muhammad, thank you

  • @niclasbraten-lindblad1677
    @niclasbraten-lindblad1677 2 ปีที่แล้ว +1

    Hey man, nice basic video. Please in the future; Take care of security as well. You are granting computer objects full control on OU.

  • @znak2001
    @znak2001 4 ปีที่แล้ว

    Excellent effort Br. Muhammad for the step by step details to configure High Availability feature on SQL2019.
    There is some audio disturbance that started towards the end.

    • @ryanesteban982
      @ryanesteban982 3 ปีที่แล้ว

      you all probably dont give a shit but does anyone know a way to get back into an instagram account??
      I was dumb forgot my password. I appreciate any help you can offer me!

    • @crosbymalcolm7305
      @crosbymalcolm7305 3 ปีที่แล้ว

      @Ryan Esteban instablaster =)

    • @ryanesteban982
      @ryanesteban982 3 ปีที่แล้ว

      @Crosby Malcolm Thanks so much for your reply. I found the site through google and im trying it out atm.
      Takes a while so I will reply here later with my results.

    • @ryanesteban982
      @ryanesteban982 3 ปีที่แล้ว

      @Crosby Malcolm It worked and I actually got access to my account again. I am so happy!
      Thanks so much you saved my ass :D

    • @crosbymalcolm7305
      @crosbymalcolm7305 3 ปีที่แล้ว

      @Ryan Esteban glad I could help xD

  • @imran84941
    @imran84941 3 ปีที่แล้ว +1

    Excellent Muhammad !! Thanks alot

    • @shehzadarshad2000
      @shehzadarshad2000  3 ปีที่แล้ว

      Ur welcome

    • @imran84941
      @imran84941 3 ปีที่แล้ว

      @@shehzadarshad2000 Notice that if you setup using Sql Standard you are able to select 1 DB per AG-group
      Enterprise more than 1DB per ag group

  • @dollardreams5811
    @dollardreams5811 4 ปีที่แล้ว +2

    Please upload some videos about replication and log shipping and how interview questions will be ask on these topics

  • @rinku-blogadmin
    @rinku-blogadmin 8 หลายเดือนก่อน

    appreciate bro, very well. but here you are using donain admin account , in production is it good practice

  • @wesg01
    @wesg01 2 ปีที่แล้ว +1

    Fantastic video! Thank you

  • @sallahallo
    @sallahallo ปีที่แล้ว

    Thanks very informative...one question, Is the listener HA ?

  • @mahendrakumar-iw2fh
    @mahendrakumar-iw2fh 4 ปีที่แล้ว

    So nice sir this is really helpful

  • @josemanuelduran8601
    @josemanuelduran8601 2 ปีที่แล้ว

    Inglés
    I am very grateful for the video, but despite doing absolutely and to the millimeter everything you do in the video, there is something wrong with me, let me explain.
    I create the availability group with the wizard and when I get to the end, it does it for you, but it doesn't do the Join 'test1' to availability gorup 'SQLGA' on 'Node2' check, but it does it for me and it stays like this, waiting and waiting... (I indicate that the ports are enabled and that from the management studio, I see from both nodes, to the other node.
    Also, since the wizard does not end, in the replicas tab, node 1 is with the replication symbol and node 2 is with a red X.
    Any help?

  • @VishunaParague
    @VishunaParague 2 ปีที่แล้ว +1

    in the video Active Dir what's the purpose of the folder that you put the SQl servers in...

    • @shehzadarshad2000
      @shehzadarshad2000  2 ปีที่แล้ว

      Vishuna u can deploy GPO or cyber security control on that folder.

  • @chrisumali9841
    @chrisumali9841 ปีที่แล้ว

    Thanks for the demo and info, have a great day

  • @munnavasu7282
    @munnavasu7282 8 หลายเดือนก่อน

    which ip we have added in connection string on web. conf file

  • @danieldunn3141
    @danieldunn3141 3 ปีที่แล้ว +1

    Hey Muhammad, nice video! Quick question, why does the database on the secondary replica stay in restoring mode? I noticed that happened in your example and the same thing happened to me as well

    • @shehzadarshad2000
      @shehzadarshad2000  3 ปีที่แล้ว +1

      th-cam.com/video/c9E0cpY2k1I/w-d-xo.html

    • @shehzadarshad2000
      @shehzadarshad2000  3 ปีที่แล้ว +1

      Kindly go through the next video I have pasted the link mostly the issue is with sql agent service double check if it is running

    • @danieldunn3141
      @danieldunn3141 3 ปีที่แล้ว

      @@shehzadarshad2000 I will go through it. I did realize that I had to change something in the AG wizard and it reset my database to manual failover and asynchronous so I believe it restored with norecovery. I was able to get it working though. Thank you

  • @اللغةالعربيةفقط-ب9ض
    @اللغةالعربيةفقط-ب9ض ปีที่แล้ว

    جزاك الله خير

  • @johnjohn-pf1ye
    @johnjohn-pf1ye 2 ปีที่แล้ว

    When adding replica, I am getting "Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement."

  • @1manbank
    @1manbank 4 ปีที่แล้ว +1

    Excellent Video !

  • @bharathvelekaturi2869
    @bharathvelekaturi2869 4 ปีที่แล้ว

    why do you need to grant connect SQL explicitly to domain account where it is already sys admin ?

  • @jarves1231
    @jarves1231 3 ปีที่แล้ว

    So these are some ways of HA in sql [Failover Cluster, Availability Groups, transactional replication] am I right?

  • @fahdbahoo1
    @fahdbahoo1 ปีที่แล้ว

    is Doman must for Always on ? or can Always on be configured without domain ?

  • @jayakrishnanjagadeesh694
    @jayakrishnanjagadeesh694 2 ปีที่แล้ว +1

    While trying to configure always on, cluster type drop down showing only two options 1.External 2.None. The windows failover cluster is not showing in the list. Why it is coming like , can u help to solve the issue.

    • @shehzadarshad2000
      @shehzadarshad2000  2 ปีที่แล้ว

      Hi Jagadeesh did you install the windows failover feature kindly install it first and then try hopefully it will resolve the issue

  • @walfrod73
    @walfrod73 2 ปีที่แล้ว

    The shared folder that is created. What exactly is that used for? Can it be created on any of the SQL nodes? But is that node goes down, what would be the impact?

    • @rinku-blogadmin
      @rinku-blogadmin 8 หลายเดือนก่อน

      shared folder is acting like quorum disk , as a best practice it always be other than cluster node. It helps in voting.

  • @dollardreams5811
    @dollardreams5811 4 ปีที่แล้ว

    Please do video about what is features will be add 2000 to 2019 versions

  • @killhha
    @killhha 4 ปีที่แล้ว

    Thanks for the help. Can the shared folder be removed after the availability group is set up or must it remain to continue the syncing functionality?

    • @jorgesmitley3797
      @jorgesmitley3797 4 ปีที่แล้ว

      Killhha did you ever get an answer to your question?

  • @jorgesmitley3797
    @jorgesmitley3797 4 ปีที่แล้ว

    Just to Clarify I am pointing My SQL Clients to the ag-listener and not the WSQLCL Windows Cluster Name or IP? Or can I do both?

    • @shehzadarshad2000
      @shehzadarshad2000  4 ปีที่แล้ว +1

      Yes u have to point the clients to the listener u can use name or ip any.

  • @quanglenhat2613
    @quanglenhat2613 3 ปีที่แล้ว

    Like. Thanks

  • @sehbdusa
    @sehbdusa 4 ปีที่แล้ว +1

    upload some work on managed instance with Microsoft Azure please

  • @jvillagalvan
    @jvillagalvan 3 ปีที่แล้ว +1

    you can not set an domain admin in a windows service

  • @microsoft365kz
    @microsoft365kz 9 หลายเดือนก่อน

    sUPER!

  • @Pierre1O
    @Pierre1O 3 ปีที่แล้ว +2

    Very bad decision to change SQL Server service logon account from Services Control Manager, you need to do it from SQL Server Configuration Manager for SQL Server to assign required privileges for this account to work properly

  • @trendsnews2024
    @trendsnews2024 3 ปีที่แล้ว +1

    Thanks my brother, but is this Active/passive or not?

  • @alcolenol
    @alcolenol 3 ปีที่แล้ว

    Brother, thanks for an explanation but I've followed all your steps but when creating AAG it shows the connection to the primary replica is not active. the command cannot be processed error 35250, do you have any solution

    • @sayedsabirhasan
      @sayedsabirhasan 3 ปีที่แล้ว

      Assalamu alaikum brother. Did you configure windows firewall? I mean did you create inbound fire wall rule on sindows?

    • @alcolenol
      @alcolenol 3 ปีที่แล้ว

      @@sayedsabirhasan Walykoumalsalam, I was disabling the firwall, you know what was the issue? I mad a cluster for VM and physical PC, so, since they are on the same subnet and firwall disabled on both nodes but unable to telnet 1433 from physical to VM, I provisioned new VM insted of physical and it works fine.

    • @sayedsabirhasan
      @sayedsabirhasan 3 ปีที่แล้ว

      @@alcolenol In that case I cannot guess anything else. Usually in production, the most common blocker is the firewall as we cannot turn it off.

  • @jarves1231
    @jarves1231 3 ปีที่แล้ว

    Is the primary sql always writing to the secondary?