title: SQL Server 2008: Unable to remove a FileStream File and Filegroup
body: <p>With SQL Server 2008 SP1, I've removed the only table that had a Filestream associated with it but each time I attempt to do the following:</p>
  
  <p>alter database ConsumerMarketingStore remove file CMS_JobInstanceFiles</p>
  
  <p>alter database ConsumerMarketingStore remove filegroup JobInstanceFiles</p>
  
  <p>I get the following exception: </p>
  
  <p>Msg 5042, Level 16, State 10, Line 2
  The file 'CMS_JobInstanceFiles' cannot be removed because it is not empty.
  Msg 5042, Level 16, State 11, Line 3
  The filegroup 'JobInstanceFiles' cannot be removed because it is not empty.</p>
  
  <p>How in the world do I get rid of the Filestream file and filegroup? Thanks!</p>