How to add database to an availability group

Sdílet
Vložit
  • čas přidán 21. 01. 2023
  • This video gives an idea how to add database to an availability group and different options to initialize the secondary database(s)

Komentáře • 17

  • @user-og4pr2qp9z
    @user-og4pr2qp9z Před rokem

    Excellent explanation keep doing more vedios for us it will help full for learners

  • @Chandrasekhar_kuntimaddi

    Your explanation is excellent, and I appreciate the effort you put into creating informative videos. Your hard work has provided us with greater clarity. Please continue to share your knowledge with us, and thank you for your dedication to helping others understand complex topics.😊

    • @chandustechnet4214
      @chandustechnet4214  Před rokem +2

      Thanks for the valuable feedback. Due to the busy schedule at work, I couldn't do videos. I will find some spare time and will do more videos.
      Thanks

  • @tonyettah
    @tonyettah Před rokem

    Excellent explanation and easy to understand. Thank you Prof. Pls, we need more videos.

  • @vithanalmahesh4544
    @vithanalmahesh4544 Před rokem +1

    Superb explanation sir..tnq sir

  • @nazishejazi2817
    @nazishejazi2817 Před rokem +1

    Nice explanation

  • @RESSY-gz6mn
    @RESSY-gz6mn Před rokem

    Please let me know how to add database from secondary server in always on thanks.

  • @mjkhan368
    @mjkhan368 Před rokem

    Hello Sir,
    Suppose our db size 1.7TB can we go for autoseeding?

    • @chandustechnet4214
      @chandustechnet4214  Před rokem

      You can, I've enabled auto seeding even for 4TB of the databases. You will have to enable the trace flag 9567 for compression on the primary. This will help in compressing the data while seeding on the secondary. One downside of using this trace flag, you would see some CPU spikes during the compression on the primary.

    • @mjkhan368
      @mjkhan368 Před rokem +1

      @@chandustechnet4214 thanks sir

  • @Ganeshay-996
    @Ganeshay-996 Před 13 dny

    how to add new availibity group wizard in always on high availablity becose not showing

    • @chandustechnet4214
      @chandustechnet4214  Před 12 dny

      What do you mean by adding a new availability group wizard? If you enable alwayson feature from configuration manager, you should be able to configure alwayson from SSMS

  • @user-mw4sx2hk6s
    @user-mw4sx2hk6s Před rokem +1

    Thank you so much sir very clear explanation
    Can you share your email id