创建数据库快照

[sql]代码库

IF EXISTS(SELECT name
          FROM   sysdatabases
          WHERE  [name] = '快照名Snapshot')
  DROP DATABASE 快照名Snapshot
 
GO
 
CREATE DATABASE 快照名Snapshot ON ( NAME = '原数据库名', FILENAME = 'D:\Database\快照名Snapshot.mdf' ) AS SNAPSHOT OF 原数据库名