MSSQLSERVER_21862
Details
Product Name |
MSSQLSERVER |
Product Version |
11.0 |
Product Build Number |
11 |
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.