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_data\HOST_147_cert_new.cer';

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

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

备服务器执行

drop CERTIFICATE HOST_147_cert

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

 

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

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