备份数据库和复制配置？
在 SQLServer 2005 中，是否可以将数据库从一个工作站迁移到另一个工作站并同时使用复制配置？
我的意思是，除了创建脚本之外。
In SQLServer 2005, is it possible to migrate a database from a workstation to another and also take the Replication configuration with it?
I mean, besides creating scripts.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
如果您要移动发布者：
- 备份 SMK、发布数据库、msdb、分发和主数据库。
- 将它们恢复到与旧服务器同名的新服务器上。
- 确保在执行恢复时使用 keep_replication 开关。
如果您要移动订阅者：
- 备份 SMK、master、msdb 和订阅数据库。
- 将它们恢复到与旧服务器同名的新服务器上。
- 确保在执行恢复时使用 keep_replication 开关。
If you're moving a publisher:
-Backup up the SMK, publication database, msdb, distribution, and the master database.
-Restore them on the new server with the same name as the old server.
-Ensure you use the keep_replication switch when doing the restore.
If you're moving a subscriber:
-Backup up the SMK, master, msdb, and subscription database.
-Restore them on a new server with the same name as the old server.
-Ensure you use the keep_replication switch when doing the restore.
复制和 SQL 代理配置存储在 MSDB 系统数据库中。如果您要迁移到的服务器具有与源服务器相同版本的 SQL Server，您应该能够还原 msdb 数据库以及用户数据库以恢复复制配置。您还需要将安全信息从源服务器传送到目标服务器。此信息存储在 master 数据库中，因此您可以在新服务器上备份和还原 master 数据库，或者编写登录脚本并在新服务器上还原它们。查看这些文章以获取更多信息：
您无法将系统数据库备份还原到不同版本的 SQL Server
http://support.microsoft.com/kb/264474
如何在之间传输登录名和密码SQL Server 实例
http://support.microsoft.com/kb/246133
使数据库可用时管理元数据在另一个服务器实例上
http://msdn.microsoft.com/en-us/library/ms187580。 ASPX
Replication and SQL Agent configuration is stored in the MSDB system database. If the server you are migrating to has the same version of SQL Server as the source server, you should be able to restore the msdb database along with your user database to get the replication configuration back. You will also need to bring over the security information from the source server to the target server. This information is stored in the master database, so you may be able to backup and restore the master database on the new server, or script out the logins and restore them on the new server. Check out these articles for more information:
You cannot restore system database backups to a different build of SQL Server
http://support.microsoft.com/kb/264474
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
Managing Metadata When Making a Database Available on Another Server Instance
http://msdn.microsoft.com/en-us/library/ms187580.aspx
正如 Microsoft 文章备份和恢复复制数据库中所述：
As noted in the Microsoft article Backing Up and Restoring Replicated Databases: