SQL Server 2012 creating a DB Snapshot

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