To create a DB snapshot:
You must include every data file in the source database, the original logical name, the new physical name and the path in the CREATE DATABASE command,
Cannot specify additional properties
Create DATABASE Db_snapshot_name on
(....) [,(....) ....]
as snapshot of db_name;
-------------------------------
Example:
Create DATABASE Studio_snapshot
On (name = ' Studio ', filename= ' E:\studio_snapshot.mdf ')
as snapshot of studio;
Go
----------------------------------------------------------------------------------------------------
Snapshot files are created as sparse files, this is the function of the NTFS file system, the snapshot files only contain the modified data, so initially, the sparse file does not contain user data
As the data is written to NTFS, space is allocated for the file, and the space allocated for each allocation is the whole number of 64K!
SQL Server creates a db snapshot