Create Snapshot for Databases with Multiple Data Files in sqlserver
<p>How to create database snapshot for databases which have primary data file (.mdf) and secondary data files (.ndf files) too.
Throws exception Missing the file databaseName_EX when I create it.<br>
The database file includes databaseName_EX.ndf and databaseName.mdf </p>

<pre><code>CREATE DATABASE databaseName_report_snap ON
(Name ='databaseNameJ',
FileName='E:\SqlData\databaseName_report.snp')
AS SNAPSHOT OF databaseName;    
</code></pre>