Setting up SQL Server High-Availability between Windows and Linux with SQL Server 2017

Sign in to queue

The Discussion

  • User profile image


  • User profile image

    Is it possible to have not only the video, but also all the T-SQL scripts used? Is there perhaps a Power Point file or some othe source, people can use and save time for copying the commands from the screen ?

  • User profile image
  • User profile image

    @TobiasT: Great walk through Tobias and Slava.  Tobias, could you also place your sudo scripts in github and any highlight any prerequisite steps required e.g. hosts file, firewall config etc.

  • User profile image

    I understand building AlwaysOn, but do you have a video on Failover settings using Pacemaker?
    This is three Linux environments.

  • User profile image
    Ysaias Portes

    Hi @TobiasT
    I am getting an error: Apparently AUTOMATIC SEEDING is not working for me...I am not sure what I missed, but getting a typical restore error in Error Log.

    Automatic seeding of availability database 'test' in availability group 'MyAGDistr' failed with a transient error. The operation will be retried.
    The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on '\var\opt\mssql\data\test.ldf'.
    File 'test_log' cannot be restored to '\var\opt\mssql\data\test.ldf'. Use WITH MOVE to identify a valid location for the file

  • User profile image

    Hello, Thank You for the nice stuff. its very helpful

Add Your 2 Cents