The FILESTREAM feature came with Microsoft SQL Server 2008 and offers a very promising functionality in processing of large data portions. Unfortunately, this function does not allow usage of database mirroring as a high availability feature of SQL database:
Sometimes you may be happy with just varbinary column type: but if you plan to configure your database for mirroring you have to remove FILESTREAM support form your database completely.
One possible solution is described here:
Alternatively you may use some easier way with SQL Management Studio:
- Start SSMS and navigate to your database.
- Select tables using FILESTREAM in column definitions and generate DROP and CREATE scripts for them
(you may need also to DROP and recreate additional tables bound via foreign keys).
- Remove FILESTREAM and FILESTREAM_ON directives in table definitions.
- Re-create tables.
- Open database properties and remove FILESTREAM file group.
If your database contains data, you may need to export the data (before 2) and re-import them (after 5).