Make a custom sbroles test script (XML)

[Mindflux]

Is this possible?

I want to check for SQL connectivity since it's not a predefined role. I'm not looking to see if I can attach to any particular instances, just that the port itself responds to an inquiry.

I see sbroles has several predefined XML files.

Would it be possibly to modify the UID in that, the name and the port information and somehow import it into VEEAM for use?

Or could one suggest a way to make a batch script to basically do the same thing (since this is a supported method)?

[Alexey D.]

Hello Ryan,

I see you are doing well and not bothered exploring B&R internals Yes, it is possible to create custom verification procedure.
Here is an example showing how to test whether port is open, at your SQL Server:

Code: Select all

 <?xml version="1.0" encoding="utf-8" ?>
<SbRoleOptions>
  <Role>
    <SbRole>
      <Id>9C0EDDD9-7BA5-48cd-AD87-2CF67F28B8AD</Id>
      <Name>SQL Server</Name>
    </SbRole>
  </Role>
  <Options>
    <SbVerificationOptions>
      <ActualMemoryPercent>100</ActualMemoryPercent>
      <MaxBootTimeoutSec>1800</MaxBootTimeoutSec>
      <AppInitDelaySec>120</AppInitDelaySec>
      <TestScripts>
        <TestScripts>
          <TestScript>
            <Name>SQL port test</Name>
            <Type>Predefined</Type>
            <TestScriptFilePath>VmConnectionTester.exe</TestScriptFilePath>
            <Arguments>%vm_ip% 1433</Arguments>
          </TestScript>
        </TestScripts>
      </TestScripts>
      <HeartbeatEnabled>True</HeartbeatEnabled>
      <PingEnabled>True</PingEnabled>
    </SbVerificationOptions>
  </Options>
</SbRoleOptions>

You can do this for any other application too, just remember to:
- Set unique <id>, not to have duplicates;
- Specify desired port near to %vm_ip% argument;

You may also adjust timeout settings (boot, application initialization);

Newly created test script will appear in UI so you can choose it. During surebackup job our VmConnectionTester.exe will try to connect to specified port (SQL Server in your case) and check whether it's open.

[Mindflux]

Thank you. It was easier than I thought. Changed a couple characters on the UID and veeam picked it right up once I went back through the application group wizard.

[AFCUIT]

This is a quick question about the <ID> tag. I see where Alexey D. replied to, "- Set unique <id>, not to have duplicates". My question is, do I just create a random ID? I appears that MindFlux may have just changed a few characters to create a new ID...is that correct?

Thank you.

[Gostev]

Correct. But I would use this just to be on the safe side > http://www.guidgenerator.com

[veremin]

Also, as mentioned in the adjacent thread, the custom role ID should be 32-character long with dashes in between. Thanks.