Original: SQL Server 2012 creating a DB Snapshot
Not all MSSQL database versions support database snapshots and are supported only with Enterprise editions.
In other versions, in the case of the business Intelligence Edition version, the following error is reported when creating a snapshot
Msg 1844, Level 16, State 1, line 1th
Business Intelligence Edition does not support Database Snapshot.
Under the Enterprise version of the database, run the following statement to create a snapshot error message
Msg 5127, Level 16, State 1, line 1th
You must specify all the files used to create the database snapshot. The file "Testtt_data" is missing.
Create Database on ( name=N'testtt', filename='f:\ TESTDATABASE\TESTTTSNAPSHOT.SS') as of TESTTT
This means that name=n ' testtt ' is not written casually when creating a snapshot. You must specify the same logical name as the data file inside the source database. The logical name of the primary data file for the original TESTTT database should be testtt_data, not testtt.
If you are unsure of the logical name of the main data file, you can run the select * from Testtt.sys.database_files where type=0 confirm, or you can use the graphical interface
So, the correct wording should be
Create Database on (
Name=N'testtt_data', filename='f:\ TESTDATABASE\TESTTTSNAPSHOT.SS') as of TESTTT
It is also important to note that if the path does not exist, an error is
SQL Server 2012 creating a DB Snapshot