CCR 环境下移动存储组

来源：互联网发布：数据库实例编辑：程序博客网时间：2024/04/29 04:55

1.停止复制

Suspend-StorageGroupCopy -Identity 'IBRSZMBS01/Second Storage Group'

2.卸载数据库

Dismount-database -Identity 'IBRSZMBS01/Second Storage Group/Public Folder Database'

3.移动数据库路径

Move-DatabasePath -Identity 'IBRSZMBS01/Second Storage Group/Public Folder Database' -EdbFilePath 'S:/Mailbox/Second Storage Group/Public Folder Database.edb' -ConfigurationOnly

4.移动sys和log文件,动作同3

move-StorageGroupPath -Identity 'IBRSZMBS01/Second Storage Group' -LogFolderPath 'S:/Mailbox/Second Storage Group' -SystemFolderPath 'S:/Mailbox/Second Storage Group' -ConfigurationOnly

5.复制以上文件

6.装载数据库

Mount-Database 'IBRSZMBS01/Second Storage Group/Public Folder Database.edb'

7.重启复制

Resume-StorageGroupCopy -Identity 'IBRSZMBS01/Second Storage Group'

8.在被动节点作5-6步骤即可(完)

9.另外一种做法:(启动被动节点存储组)

挂起存储组/更新(选择删除已存在的日志文件)即可

检查复制状态:

Get-StorageGroupCopyStatus -Identity:'IBRSZMBS01/Second Storage Group'

suspend的值如果为false,则将重新启动存储组(自动,无须额外操作)