title: Why am I obtaining these alter database error trying to create a DB using a DDL script obtained from SQL Server 2012 on SQL Server 2008?
body: <p>I am pretty new to SQL Server, and I am finding the following difficulties.</p>
  
  <p>I extract the DDL to create a database from a SQL Server 2012 machine, then I run this DDL creating the database on an old SQL Server 2008 instance, and I am getting the following errors:</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 6, Line 1<br>
    Incorrect syntax near 'FILESTREAM'.</p>
    
    <p>Msg 102, Level 15, State 6, Line 1<br>
    Incorrect syntax near 'TARGET_RECOVERY_TIME'.</p>
  </blockquote>
  
  <p>The first error is on this line:</p>
  
  <pre><code>ALTER DATABASE [SIGLA-AZIENDA_SIGLA-AOO] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
  GO
  </code></pre>
  
  <p>The second error is on this line:</p>
  
  <pre><code>ALTER DATABASE [SIGLA-AZIENDA_SIGLA-AOO] SET TARGET_RECOVERY_TIME = 0 SECONDS 
  GO
  </code></pre>
  
  <p>What could be the causes of these error? Is related to the different version of SQL Server? From what I know the involved project is not using something like <strong>BLOB</strong> field so I think that FILESTREAM are not mandatory.</p>
  
  <p>How can I try to solve these issues?</p>