围炉网

一行代码,一篇日志,一个梦想,一个世界

log shipping 部署笔记

在部署log shipping 的secondary database settings时, 如果选择 Yes, generate a full backup of the primary database and restore it into the secondary database (and create the secondary database if it doesn't exist) 总是报错,提示secondary database 读取backup 文件时没有权限。

workaround:

直接手动在secondary database 上restore backup 文件。注意restore options要设为 restore with norecovery 或者 restore with standby 而非默认的restore with recovery

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注

沪ICP备15009335号-2