sqlserver镜像过期处理方法

主服务器看过期时间

select name,start_date,expiry_date from sys.certificates where name not like '##%'

原本expiry_date时间已经过了

----------------------------------------------------------

处理过程

主服务器

create CERTIFICATE HOST_147_cert_new WITH SUBJECT = 'HOST_147 certificate',START_DATE = '03/29/2013',EXPIRY_DATE? = '09/17/2999';
go
ALTER ENDPOINT Endpoint_Mirroring?
FOR DATABASE_MIRRORING ( AUTHENTICATION = CERTIFICATE HOST_147_cert_new)
go
DROP CERTIFICATE HOST_147_cert
GO
BACKUP CERTIFICATE HOST_147_cert_new TO FILE = 'E:ss2path_dataHOST_147_cert_new.cer';

将主服务器上的'E:ss2path_dataHOST_147_cert_new.cer'拷贝到备服务器上

------------------------------------------------------------------------------------------------------------

备服务器执行

drop CERTIFICATE HOST_147_cert

create CERTIFICATE HOST_147_cert AUTHORIZATION HOST_147_user FROM FILE = 'E:ss2path_dataHOST_147_cert_new.cer';
alter database 出版社 set partner resume-----基本不会断开，看情况执行

?

-----------------------------

然后备库重复主库操作，主库重复备库操作

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!