Submitted by	Category	Review Cycle	.	Public
Joachim Mutter/sysarc on 06/23/2008 at 10:57 AM	SQLServer\Code

It's a bit hard to figure out the creation and restore of a database with the snapshot machanism.
It's nothing magic if you know, how to set the parameters.

The syntax:

CREATE DATABASE database_snapshot_name 
    ON
        (
        NAME = logical_file_name,
        FILENAME = 'os_file_name' 
        ) [ ,...n ]
    AS SNAPSHOT OF source_database_name

ProcessSnapshot
@DBName varchar(128) --This is the database names
@Name AS VARCHAR(128) --This is the logical name, could be retrieved by sp-helpdb 'DBName' or via properties dialog
@Filepath AS VARCHAR(128) --The path of the phyical file location, with no postfixed backslash
@mode as smallint-- -- 1 : Create snapshot
-- 2 : Restore database
-- 3 : Drop snapshot
@szDate as varchar(20) -- If given, use this as Snapshot name exte3nsion, if not, create it dynamically

Code