data mirror

Mark,

Ok .. it seems first of all that there is no way to do the setup using the GUI/Wizard. I always get the error described above even if the endpoints are already defined and started. I have discover that for strange reason if I create endpoint using three differents port (I have three independant server so according to the doc I should be able to use the same port) it works but only using command line:
These are the steps I have to go through to have the mirror configured:

1- backup on the principal
2- restore on the mirror with norecovery
3 - create endpoint
      principal: state= started port=5022 role=partner
      mirror: state=started port=5023 role=partner
      witness: state=started port=5024 role=witness
4 - setup the mirror
      mirror site: alter db set partner='TCP://itanium8.sql.net:5022'
      principal site: 
         alter db set partner='TCP://itanium9.sql.net:5023'
         alter db set partner='TCP://itanium10.sql.net:5024'
But again no way to set it up with the wizard....
Thanks
Jerome

如何建立一个使用WIN验证的数据镜像Witness服务器

要为数据库指定witness,须设置witness服务器上的角色到数据库实例
虽然witness服务器实例可以运行在主服务器或者镜像服务器上,但这样减少了灵活性
我们推荐witness服务器分配到不同的机器上,为了保证安全,我们推荐设置SAFETY属性为FULL

下面实例指点如何建立WIN验证的WITNESS

1.在服务器上建立端点,监听在7022端口


CREATE ENDPOINT Endpoint_Mirroring
    STATE=STARTED
    AS TCP (LISTENER_PORT=7022)
    FOR DATABASE_MIRRORING (ROLE=WITNESS)
GO

2.为从服务器实例的用户帐号建立一个SQL登录,假设WITNESS运行在SOMEDOMAIN/witnessuser上,而从服务器运行在MYDOMAIN/dbousername上,那么为从服务器建立一个登录如下:
--Create a login for the partner server instances,
--which are both running as MYDOMAIN/dbousername:
USE master ;
GO
CREATE LOGIN [MYDOMAIN/dbousername] FROM WINDOWS ;
GO
--Grant connect permissions on endpoint to login account
--of partners
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [MYDOMAIN/dbousername];
GO
3.在每一个从服务器实例上,为WITNESS实例上用户建立一个登录,如下
--Create a login for the witness server instance,
--which is running as SOMEDOMAIN/witnessuser:
USE master ;
GO
CREATE LOGIN [SOMEDOMAIN/witnessuser] FROM WINDOWS ;
GO
--Grant connect permissions on endpoint to login account
--of partners
GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [SOMEDOMAIN/witnessuser];
GO
4.在主服务器上,设置witness
ALTER DATABASE AdventureWorks
    SET WITNESS =
    'TCP://WITNESSHOST4:7022'
GO

阅读更多
个人分类:
上一篇SQL2005中的HTTP端点
下一篇SQL2005报表服务不能启动问题总结报告
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭