title: How to create a database snapshot in SQL Server 2008 R2
body: <p>I used the below command to create a database snapshot in SQL Server 2008 R2:</p>
  
  <pre><code>  CREATE DATABASE "dbss" ON  (
    NAME = "os-file-name",
    FILENAME = 'path')
    AS SNAPSHOT OF "dbName";
    GO
  </code></pre>
  
  <p>I got this error:</p>
  
  <blockquote>
    <p>Database Snapshot is not supported on Standard Edition (64-bit).</p>
  </blockquote>
  
  <p>Does anyone knows how can I create a database snapshot in SQL Server 2008 R2? </p>