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