Does SQL Server mirroring support FILESTREAM  filegroups?

Varshini S
Varshini S used Ask the Experts™
on
What are FILESTREAM  filegroups in SQL Server? Does SQL Server 2017 mirroring support   FILESTREAM  filegroups?
I'm using following SQL script to find out FILESTREAM  filegroups in SQL DB.  Is the script right? please let me know
select * from information_schema.columns where data_type='VARBINARY'
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
FILESTREAM allows to store any file (or better said unstructured data) outside the standard SQL Server database in the local file system. More info: https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server?view=sql-server-2017

FILESTREAM mirroring and several other features are not supported on SQL Server.
More info: https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-compatibility-with-other-sql-server-features?view=sql-server-2017

Your query
select * from information_schema.columns where data_type='VARBINARY'
does not show FILESTREAM filegroups but just varbinary columns used in your data tables.

Try this query:
USE YourDatabase
GO
SELECT * FROM sys.filegroups

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial