Comprehensive data protection for all workloads
Post Reply
Mindflux
Enthusiast
Posts: 32
Liked: never
Joined: Nov 10, 2010 7:52 pm
Full Name: RyanW
Contact:

Make a custom sbroles test script (XML)

Post by 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.

Re: Make a custom sbroles test script (XML)

Post by 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
Enthusiast
Posts: 32
Liked: never
Joined: Nov 10, 2010 7:52 pm
Full Name: RyanW
Contact:

Re: Make a custom sbroles test script (XML)

Post by 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
Novice
Posts: 4
Liked: never
Joined: Jun 01, 2012 4:05 pm
Full Name: Russ Williams
Contact:

Re: Make a custom sbroles test script (XML)

Post by 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
SVP, Product Management
Posts: 26683
Liked: 4268 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Make a custom sbroles test script (XML)

Post by Gostev »

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

veremin
Product Manager
Posts: 17834
Liked: 1661 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Make a custom sbroles test script (XML)

Post by veremin »

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

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 30 guests