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

Sign in to queue

The Discussion

  • User profile image
    Virgin

    Tremendous....

  • User profile image
    Neitour

    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
    TobiasT
  • User profile image
    Raymondo73

    @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
    yangjiayi

    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

Add Your 2 Cents