--创建数据库快照
create database SchoolManagement_SnapShot_0425
on
(
NAME=SchoolManagement,
filename='E:\SchoolManagement_SnapShot_0425.mdf'
)
AS snapshot of SchoolManagement
--用快照恢复数据库
restore database SchoolManagement from database_snapshot='SchoolManagement_SnapShot_0425'
SELECT * FROM sys.databases
WHERE NAME='SchoolManagement_SnapShot_0425'
--删除快照
drop database SchoolManagement_SnapShot_0425
数据库快照
最新推荐文章于 2024-09-03 15:27:57 发布