About the agent for SQL Server 2008 FILESTREAM
Prev Introducing VCS agents for SQL Server 2008 Next

About the agent for SQL Server 2008 FILESTREAM

FILESTREAM in SQL Server 2008 enables SQL-based applications to store unstructured data, such as documents and images, on the file system. FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SQL statements can insert, update, query, search, and back up FILESTREAM data. Win32 file system interfaces provide streaming access to the data.

The agent for SQL Server 2008 FILESTREAM enables FILESTREAM, monitors the status, and disables it. The agent makes FILESTREAM highly available in a clustered environment.

Specific agent functions include the following:

Online

Enables FILESTREAM on the node on which the service group comes online.

Offline

Disables FILESTREAM on the node on which the service group goes offline.

Monitor

Monitors FILESTREAM status on the node on which the service group is online. If the agent is unable to query the status of FILESTREAM or if FILESTREAM is disabled on the node, the FILESTREAM resource in the service group faults.
Prev Up Next
Attribute definitions for a SQL Server 2008 agent Home Resource type definition for SQL Server 2008 FILESTREAM agent