SQL Server:如果我没有为 RESTORE DATABASE 指定 RECOVERY 模式,默认值是什么?
来自: http://msdn.microsoft.com/en-us/library/ms187495 .aspx
示例:
--恢复常规日志备份(从备份集2)。
RESTORE LOG AdventureWorks2008R2
FROM DISK = 'Z:\SQLServerBackups\AdventureWorks2008R2FullRM.bak'
WITH FILE=2,
NORECOVERY;
我的问题:如果我不指定 NORECOVERY
,它会是默认值吗?我有很多以这种方式迁移的数据库,但我不确定如何判断使用了哪种恢复模型。
谢谢
From: http://msdn.microsoft.com/en-us/library/ms187495.aspx
Example:
--Restore the regular log backup (from backup set 2).
RESTORE LOG AdventureWorks2008R2
FROM DISK = 'Z:\SQLServerBackups\AdventureWorks2008R2FullRM.bak'
WITH FILE=2,
NORECOVERY;
My question: If I don't specify NORECOVERY
, will it be the default? I have a bunch of databases that were migrated in this fashion and I'm not sure how to tell which recovery model was used.
Thanks
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
恢复是默认设置。请参阅 RESTORE 命令的文档,其中指出:
RECOVERY is the default. See the documentation for the RESTORE command, which states: