建立
create database classsnap
on(name=TEST,filename='C:\Users\dqd\Desktop\SQLns\classinfo1.dfn')
as snapshot of TEST
恢复
use master
restore database TEST
from database_snapshot='classsnap'/*从classsnap快照中*/
建立
create database classsnap
on(name=TEST,filename='C:\Users\dqd\Desktop\SQLns\classinfo1.dfn')
as snapshot of TEST
恢复
use master
restore database TEST
from database_snapshot='classsnap'/*从classsnap快照中*/