Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/2/3 6:34:06 MS SQL 2005的新功能创建数据库快照_[SQL Server教程]
数据库快照是MSSQL2005的新功能,仅在 Microsoft SQL Server 2005 Enterprise Edition 中可用。而且SQL Server Management Studio 不支持创建数据库快照,创建快照的唯一方式是使用 Transact-SQL。
CREATE DATABASE AdventureWorks_snapshot_0600 ON
( NAME = AdventureWorks_Data, FILENAME =
AS SNAPSHOT OF AdventureWorks;
RESTORE DATABASE AdventureWorks FROM DATABASE_SNAPSHOT = AdventureWorks_snapshot_0600
DROP DATABASE AdventureWorks_snapshot_0600
赞