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

The Discussion

• 

  Tremendous....

• 

  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 ?

• 

  Uploaded demo scripts here: https://github.com/TobiasSQL/samples/tree/master/linux_windows_ags

• 

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

• 

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

• 

  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

• 

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

  http://www.powerbitraining.com.au/power-bi-training/