Verify SQL Database

Critical Step

Defines whether the step is critical for machine recovery.

If you mark the step as Critical, its failure for a machine from a critical inventory group will halt the plan.

Yes

Windows Credentials

Credentials required to gain access to the SQL Server instance that uses Windows Authentication.

If the SQL Server instance you want to check uses Windows Authentication, the provided credentials will be used to connect to both the in-guest OS and the SQL instance. In this case, specify a value for the Windows Credentials parameter, and leave the SQL Credentials parameter value empty.

—

SQL Credentials

SQL account credentials required to gain access to the SQL Server instance that uses SQL Server Authentication.

If the SQL Server instance you want to check uses SQL Server Authentication, Orchestrator will use SQL Server credentials to access the SQL instance, and Windows credentials to access the in-guest OS. That is why you must specify values for both the SQL Credentials and Windows Credentials parameters.

Note: The SQL Credentials parameter does not accept Windows credentials.

—

SQL Instance

Name of the SQL instance to check.

Note: To check all detected instances, select ALL.

ALL

SQL DB

Name of the SQL database to check.

Note: To check all detected databases, select ALL.

ALL

Execute Location

Defines whether the script will run on the Veeam Backup & Replication server, on the Orchestrator server or on the in-guest OS.

In-Guest OS (not editable)

Timeout

Maximum amount of time (in seconds) for the step to execute.

300

Retries

Number of retries that will be attempted if the step fails on the first try.

10

During Failback and Undo

Defines whether the step will be executed during the Failback and Undo Failover operations.

Skip

During DataLab Tests

Defines whether the step will be executed during plan testing in a DataLab.

Execute