About the Disaster Recovery Orchestrator agent for SQL Server FILESTREAM

The Disaster Recovery Orchestrator agent for SQL Server FILESTREAM enables FILESTREAM storage for the specified SQL Server instance, monitors its status, and disables it.

FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system.

The FILESTREAM resource type represents this agent.

Agent functions

Online

Enables FILESTREAM on the system.

Offline

Disables FILESTREAM on the system.

Monitor

Monitors FILESTREAM status on the system. If the agent is unable to query the status of FILESTREAM or if FILESTREAM is disabled on the system, the FILESTREAM resource in the application monitoring configuration faults.

Clean

Cleans up the resource state after the resource fails to come online, fails to go offline, or fails to be detected as online even though it is in the ONLINE state.

Resource type definition
type SQLFilestream (
static i18nstr ArgList[] = { InstanceName }
i18nstr InstanceName
)
Agent attributes

Table: Disaster Recovery Orchestrator agent for SQL Server FILESTREAM - required attribute

Attribute

Description

Name: InstanceName

Type: String

Dimension: Scalar

Name of the SQL Server instance for which FILESTREAM is configured.

If the value of this attribute is empty, the agent monitors the default SQL Server instance (MSSQLSERVER).