Delen via

  • Artikel

MSSQLSERVER_21862

Details

Product Name

MSSQLSERVER

Product Version

10.0

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'.

Explanation

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

User Action

Change the publication synchronization method to something other than database snapshot or database_snapshot_character, or just exclude the FILESTREAM column from the publication.