title: How to disable Filestream on SQL Server 2008 R2 to enable mirroring?
body: <p>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:</p>
  
  <pre><code>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&amp;ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&amp;EvtID=Alter+Database&amp;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&amp;ProdVer=10.50.4000&amp;EvtSrc=MSSQLServer&amp;EvtID=5574&amp;LinkId=20476
  
  ------------------------------
  BUTTONS:
  
  OK
  ------------------------------
  </code></pre>
  
  <p>I don't even have files on my database so I'd like to turn off filestream, how can I do it?</p>
  
  <p>Thanks</p>