| title | MSSQLSERVER_21862 | |
|---|---|---|
| description | MSSQLSERVER_21862 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| ms.date | 04/04/2017 | |
| ms.service | sql | |
| ms.subservice | supportability | |
| ms.topic | reference | |
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
| Attribute | Value |
|---|---|
| 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.