monitor
#monitor#21862

21862

Product Name MSSQLSERVER Event ID 21862 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum21862 Message Text FILESTREA

Product

Name

MSSQLSERVER

Event ID

21862

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

SQLErrorNum21862

Message Text

FILESTREAM columns cannot be published in a publication by using a synchronization

method of either ‘database snapshot’ or ‘database snapshot character’.

Because FILESTREAM data cannot be accessed through a database snapshot, the snapshot

agent will be unable to read FILESTREAM data when either the

database snapshot

or

database_snapshot_character

parameter is specified for the synchronization method of the

publication.

Change the publication synchronization method to something other than

database snapshot

or

database_snapshot_character

, or just exclude the FILESTREAM column from the publication.

Expand table