go
------------------------------------在数据库快照和数据库中查询T1和T2表
use DemoDB
select * from T1
select * from T2
go
use DemoDB_dbsnapshot_200510201600
select * from T1
select * from T2
go
------------------------------------------
--注：如果需要周期创建快照，可以创建作业
------------------------------------------在DemoDB中更新数据
use DemoDB
update T1 set name='Funny' where id=1
go
-----------------------------------------数据库快照和数据库中查询T1和T2表
select * from Demodb.dbo.T1
select * from DemoDB_dbsnapshot_200510201600.dbo.T1
select * from DemoDB_dbsnapshot_200510201600.dbo.T2
----------------------------------------在DemoDB中更新数据
use DemoDB
update T1 set name='Bob' where id=1
go
----------------------------------数据库快照和数据库中查询T1和T2表
select * from Demodb.dbo.T1
select * from DemoDB_dbsnapshot_200510201600.dbo.T1
select * from DemoDB_dbsnapshot_200510201600.dbo.T2
-----------------------------------------------
/*使用数据库快照还原整个数据库*/
-------------------------------------------使用数据库快照恢复DemoDB数据库
use master
restore Database DemoDB from Database_snapshot='DemoDB_dbsnapshot_200510201600'
-------------------------------------------
select * from DemoDB.dbo.T1
select * from DemoDB_dbsnapshot_200510201600.dbo.T1
-------------------------------------------
use master
drop database DemoDB_dbsnapshot_200510201600 --删除数据库快照
drop Database DemoDB --删除数据库
转载自：http://wenku.baidu.com/link url=2TnLqDON6Lv_xY9j800t98axR_wswnGCepl8SPeMaaDtaKSSJKFXaR4Z2M0DS3Fd1udxmKLEkN7zX5kC79tUr1l6BU4p5uho5a3KszdrdbK