|
Category: SQL Server
view more software Tips and Tricks
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. |