创建快照
Name = LivePortal,
--快照文件地址
FileName = 'E:\LivePortal_SnapShot.ss'
)
AS SNAPSHOT OF LivePortal
查询快照数据库中的数据
use Snapshot_LivePortal
用快照恢复数据库
RESTORE DATABASE LivePortal from
DATABASE_SNAPSHOT = 'Snapshot_LivePortal';
删除快照
DROP DATABASE Snapshot_LivePortal
create database Snapshot_LivePortal ON(
Name = LivePortal,
--快照文件地址
FileName = 'E:\LivePortal_SnapShot.ss'
)
AS SNAPSHOT OF LivePortal
查询快照数据库中的数据
use Snapshot_LivePortal
用快照恢复数据库
RESTORE DATABASE LivePortal from
DATABASE_SNAPSHOT = 'Snapshot_LivePortal';
删除快照
DROP DATABASE Snapshot_LivePortal