创建数据库快照
- create database 快照数据库名
- on
- (
- name=数据库属性名,
- filename='快照文件存储路径'
- )
- as snapshot of 被快照的数据库名;
- go
例:
- create database test_snapshot_1
- on
- (
- name=data1,
- filename='c:\snapshot\test_snap_1.ss'
- )
- as snapshot of data_test_1;
- go
还原数据库快照
- restore database 快照数据库名
- from database_snapshot='快照数据库名'
- go
例:
- restore database test_snapshot_1
- from database_snapshot='test_snapshot_1'
- go
转载于:https://blog.51cto.com/51you/959139