Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_21862

Product Name

MSSQLSERVER

Product Version

10.50

Product Build Number

10.00.1399.60

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft