一、创建数据库快照命令:
CREATE DATABASE SCDBKZ
ON
(
NAME = 'SCDB',
FILENAME = 'E:\SQL SERVER 2008\SCDBKZ1.mdf'
)
AS SNAPSHOT OF SCDB;
CREATE DATABASE SCDBKZ /*快照名*/
ON
(
NAME = 'SCDB', /*逻辑名称*/
FILENAME = 'E:\SQL SERVER 2008\SCDBKZ1.mdf' /*快照保存地址*/
)
AS SNAPSHOT OF SCDB; /*原数据库名称*/