Database Mirroring in SQL Server || Database Mirroring Configuration || Ms SQL

Поделиться
HTML-код
  • Опубликовано: 3 дек 2024

Комментарии • 52

  • @rahulshende2526
    @rahulshende2526 2 года назад +5

    Hi Sir,
    Thank's a lot for this video.
    My all doubts are cleared after watching this configuration of mirroring.
    Thank you once again.

  • @srinaths6381
    @srinaths6381 3 года назад +8

    U r dominated techbrothers 🤗

  • @abe92139
    @abe92139 2 года назад

    Thanks!

  • @DilipSunsariya
    @DilipSunsariya Год назад +1

    Hi
    Thank you very much for the very informative video.

  • @banalasiva5743
    @banalasiva5743 3 года назад +2

    Super video i understand clearly

  • @HiranthaIddamalgoda
    @HiranthaIddamalgoda 7 месяцев назад

    Nice. Well explained. Thank you

  • @suryakant2418
    @suryakant2418 2 года назад

    Hi.. Thanks for wonderful video.

  • @ajbxhrfgirc-fy9lg
    @ajbxhrfgirc-fy9lg Год назад +1

    Excluding the endpoint videos . What is the setup u did with vms before begining the main topic .please tell 😢

  • @SunindraSeepana
    @SunindraSeepana 3 года назад

    Failoer concept is excellent sir God bless you

    • @righttolearnbk
      @righttolearnbk  3 года назад

      Thank you.

    • @SunindraSeepana
      @SunindraSeepana 3 года назад

      Sir could you please upload Clustering cocepts

    • @righttolearnbk
      @righttolearnbk  3 года назад +1

      @@SunindraSeepana
      At present I don't have the setup ready in my pc, we need good hardware configuration, planning to do it with Azure Virtual Machines..

  • @pramod1234ist
    @pramod1234ist Год назад

    Thanks a lot sir.....

  • @geeksified
    @geeksified Год назад

    can you setup db mirroring on servers on 2 different AWS Lightsail accounts? We're trying to be online as much as possible as one of our script is messing up the server, and it hangs the server up that it becomes unresponsive. Until we found where this script is or what issue it does create, we need to be able to serve our app as much as we can.
    I haven't done with the video yet, but your sample is basically within a single domain.

  • @Motivandovidasz
    @Motivandovidasz 8 месяцев назад

    Muito obrigadoo !

  • @mrgogate
    @mrgogate 2 года назад

    Super Boss !!

  • @a2zguide216
    @a2zguide216 Год назад +1

    Can I configure Database Mirroring on the same computer with a different SQL Server Instances

  • @sontosh007
    @sontosh007 Год назад

    Thank you

  • @SudarshanReddy897
    @SudarshanReddy897 6 месяцев назад

    great video..have one doubt that if we want to failover multiple databases just say like 20db's, how can we do at a time?

  • @ravulakishan5998
    @ravulakishan5998 3 года назад

    thank you bro so much

  • @3bdulla3ngineer
    @3bdulla3ngineer 3 года назад +2

    Hi
    Thank you very much for the very informative video.
    I have a question regarding mirroring operating modes and MS SQL editions. High Performance (asynchronous) mode is supported only on MS SQL Enterprise edition, right? I cannot run it on MS SQL Standard edition, right?

  • @shreharshethaauto8428
    @shreharshethaauto8428 2 года назад

    hi sir while configuring to mirroring in mirror server we are getting listeners port getting 5023 where as principal instance listeners port is 5022

  • @advishwakumaraamarasinghe1486
    @advishwakumaraamarasinghe1486 11 месяцев назад

    Thanks

  • @SudeerRao
    @SudeerRao Год назад

    Can you set up database mirroring on virtual machines hosted on AWS with SQL Server installed. Also without domain controller.?

    • @righttolearnbk
      @righttolearnbk  Год назад +1

      Yes we can. We can even setup between different domains

    • @proteinfoodtravel
      @proteinfoodtravel Год назад

      @@righttolearnbk can you make a video on this sir.

  • @sqlserver6395
    @sqlserver6395 3 года назад

    can we configure logshipping in clustering if possible how? can please explain me

  • @sivasankar7013
    @sivasankar7013 Год назад

    But for 2008 it asks database option in mirror server to restore

  • @HARISHREDDY-kn5qe
    @HARISHREDDY-kn5qe 2 года назад

    why didn't we configure mirror DB in standby mode?

  • @kshanker72
    @kshanker72 2 года назад

    how to fix if someone has changed recovery model to simple for mirrored database

  • @toprerishi
    @toprerishi 7 месяцев назад

    Is Mirror possible for SQL Express?

  • @shaficicabdi9553
    @shaficicabdi9553 4 года назад

    hello I have a problem in SQL Server 2014 Mirroring " the server network address cannot be reached mirroring 1418" and I am using IP address both Computers Principle and Mirror Servers.
    so, how to fix it?

    • @righttolearnbk
      @righttolearnbk  4 года назад

      Could be a endpoint issue. Watch this ruclips.net/video/BF0S8UGJT5o/видео.html

    • @rahulshende2526
      @rahulshende2526 2 года назад

      Make sure you have restore FULL & T_LOG Backup with No Recovery Option.

  • @charlykjoseph
    @charlykjoseph 3 года назад

    Which edition of 2014?

  • @venkateshthummuru9245
    @venkateshthummuru9245 3 года назад

    how did you configure 5022 as port for both principal and mirror servers

    • @delta3black563
      @delta3black563 3 года назад

      Because database are in different machine.

    • @rahulshende2526
      @rahulshende2526 2 года назад

      We can configure mirroring with 5022 Port if we are using different Server / Machin.
      If we configure mirroring on same / only one Machin then port will be 5022(Principal) & 5023(mirror).

  • @suryakant2418
    @suryakant2418 2 года назад

    I am trying to create mirror with two machines but getting error 923

  • @JSunilKumar0508
    @JSunilKumar0508 9 месяцев назад

    How to troubleshoot 927 error in Database Mirroring?

  • @dragonballsupere6316
    @dragonballsupere6316 3 года назад

    Sir,What about service account id should be same or not

    • @righttolearnbk
      @righttolearnbk  3 года назад +1

      Service account need not to be same. I have tested this in production environment and it is working well.

    • @dragonballsupere6316
      @dragonballsupere6316 3 года назад

      @@righttolearnbk Thanks Sir, but can we configure 1 with window authentication and 1 with sa

  • @anandprakashtiwari1457
    @anandprakashtiwari1457 7 месяцев назад

    Is it clustered setup

  • @racemchoura5441
    @racemchoura5441 2 года назад

    please the script of mirroring

  • @Venkat6728
    @Venkat6728 3 года назад

    Ms SQL server standard support database mirroring.