SQL群集间迁移数据库问题

Question

准备把应用从老群集迁移到新部署的群集，计划是把用户数据库从老群集分离，拷贝到新群集后再附加，同时master数据库从老数据库备份再恢复到新群集数据库上，请问此方法是否可行？是否合理？有没有更简单的方法？另外还有恢复master数据库我知道要用DAC链接，单机上我会操作，把sqlserver服务停了加-m参数，重启。但是群集环境下如何操作？

Answer 1

Can backup/restore master db if both clusters have same version, service pack and db file path. For user dbs, better to do backup/restore too instead of detaching/attaching.

Answer 2

Can backup/restore master db if both clusters have same version, service pack and db file path. For user dbs, better to do backup/restore too instead of detaching/attaching.

那么在群集上恢复master数据库是不是和单机上的一样呢?

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 3

同样的问题，群集上如何进入单用户模式，单机上我是加参数-m 群集上似乎不行啊，我把服务停了加-m后没法启动服务。

Answer 4

Restoring master db on cluster is same as on standalone server, you can start sql in single user mode by adding -m in startup parameters in sql server configuration manager then restart sql there. Or add -m in services applet on active node then restart sql service in applet (not in config manager nor cluster admin).

Answer 5

你好，

在群集环境下还原master数据库，需要在active节点上先将SQL Server 资源停用掉，然后在命令提示符下使用单用户模式启动SQL Server，还原master数据库，最后在群集管理器上重新启动SQL Server服务。请参考这边文章：How do you restore the master database on a SQL Server cluster?

 

---

Stephanie Lv

TechNet Community Support