首页 > 数据库技术 > 详细

master db 只能做full backup

时间:2016-04-24 21:24:44      阅读:266      评论:0      收藏:0      [点我收藏+]

今天在做Differential 备份时,发现 master db 只能做full backup,原因是master只能处于Recovered 状态,不能处于NoRecovery(recovering)状态。

You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database.

 

参考文档:Differential backup of master database?

You can only perform a full backup of the master database. It is confirmed that SQL Server is designed to allow only FULL backup of master database.

But why? For differential backups to be applied on a database, the database has to be in NORECOVERY (Recovering) state. But SQL Server does not allow master database to be restored without recovery. Master database has to be in Recovered status always.

 

master db 只能做full backup

原文:http://www.cnblogs.com/ljhdo/p/5428037.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!