2006-08-15

MSSQL 2005的新功能创建数据库快照

来源: 网页教学网作者:佚名评论 0 条

DATABASE AdventureWorks_snapshot_0600 ON

( NAME = AdventureWorks_Data, FILENAME =

'E:\SQL2005\MSSQL.1\MSSQL\Data\AdventureWorks_snapshot_0600.ss' )

AS SNAPSHOT OF AdventureWorks;

RESTORE DATABASE AdventureWorks FROM DATABASE_SNAPSHOT = AdventureWorks_snapshot_0600

DROP DATABASE AdventureWorks_snapshot_0600

共4页: 上一页 [1] [2] [3] 4 下一页

(本文仅表明作者个人观点,不代表本站及其管理员立场.) 推荐收藏投稿打印返回关闭