在做数据库双机备份,配置见证服务器时,命令ALTER DATABASE <DATABASE> SET WITNESS = 'TCP://xxxx:5022'出错
Msg 1456, Level 16, State 3, Line 1
The ALTER DATABASE command could not be sent to the remote server instance 'TCP://xxxx:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.
现在高保护性做好了,不过需手动切数据库服务器,无法实现自动转移,故配置见证服务器以实现自动转移。
见证服务器可进行远程连接,且防火墙也开放1433及5022端口、见证服务器配置与镜像服务器一样,不过将Endpiont_Mirror的role设置为witness,非partner。求指教
Msg 1456, Level 16, State 3, Line 1
The ALTER DATABASE command could not be sent to the remote server instance 'TCP://xxxx:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.
现在高保护性做好了,不过需手动切数据库服务器,无法实现自动转移,故配置见证服务器以实现自动转移。
见证服务器可进行远程连接,且防火墙也开放1433及5022端口、见证服务器配置与镜像服务器一样,不过将Endpiont_Mirror的role设置为witness,非partner。求指教
3台服务器均在一个域内