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 原数据库名 |