Search code examples
sql-serverdatabase-mirroringsqlfilestream

How to disable Filestream on SQL Server 2008 R2 to enable mirroring?

I'm enabling database mirroring on SQL Server 2008 R2, I've already configured my servers but when trying to start mirroring I get the following error:

TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'PlaneamientoComercialDB'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

A database cannot be enabled for both FILESTREAM storage and Database Mirroring. (Microsoft SQL Server, Error: 5574)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=5574&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

I don't even have files on my database so I'd like to turn off filestream, how can I do it?

Thanks

Solution

  • Although I don't have any columns that uses FILESTREAM, for some reason I had a filegroup containing filestream. I could solve the issue by removing the filegroup

    ALTER DATABASE MyDBName
REMOVE FILEGROUP MyFileGroupName

    Thanks