log shipping 部署笔记

【声明】本文为AdamsLee原创,转载请注明出自围炉网并保留本文有效链接: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

此条目发表在未分类分类目录,贴了, 标签。将固定链接加入收藏夹。