Home / Software / Tips and Tricks / How to create a SQL server Database Snapshots?

How to create a SQL server Database Snapshots?

Updated:  02/28/2017 18:02 PM
Author:  Shiju Mathews

Status:    Resolved.


A database snapshot can be created by Issuing a CREATE DATABASE statement on the files using the AS SNAPSHOT OF clause. Creating a snapshot requires specifying the logical name of every database file of the source database. The syntax is as follows:.

Example:


Example:


The database can be restored from that Snapshot as follows.