始终打开：主数据库重定位 [英] Always on : Primary database relocation

问题描述

如果我想将数据库文件重定位到主副本中的另一个更快的驱动器，是否需要重建整个复制???

解决方案

< blockquote>如果我想将数据库文件重定位到主副本中的另一个更快的驱动器，是否需要重建整个复制???

不，它不会。您必须使用alter database命令移动文件，然后使SQL Server（在辅助副本上）脱机，移动数据和日志文件，然后将其联机。 

If I would like to relocate a database files to another faster drive in the primary replica, is it required to rebuild the whole replication ???

解决方案

If I would like to relocate a database files to another faster drive in the primary replica, is it required to rebuild the whole replication ???

No it would not. You have to use alter database command to move the files then take SQL Server (on secondary replica ) offline, move the data and log files and then bring it online. 

这篇关于始终打开：主数据库重定位的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！