mssql2008镜像

备份主体库及事务日志至镜像还原

 
主体上执行
USE MASTER
GO
CREATE ENDPOINT EP1
AS TCP(LISTENER_PORT=5021)
FOR DATABASE_MIRRORING (ROLE=PARTNER,ENCRYPTION=SUPPORTED)
GO
ALTER ENDPOINT EP1 STATE=STARTED
GO
GRANT CONNECT ON ENDPOINT::"EP1" TO "NT AUTHORITY\NETWORK"
GO

 
 
镜像上执行
USE MASTER
GO
CREATE ENDPOINT EP2
AS TCP(LISTENER_PORT=5022)
FOR DATABASE_MIRRORING (ROLE=PARTNER,ENCRYPTION=SUPPORTED)
GO
ALTER ENDPOINT EP1 STATE=STARTED
GO
GRANT CONNECT ON ENDPOINT::"EP2" TO "NT AUTHORITY\NETWORK"
GO

镜像上执行
 
ALTER DATABASE zhangjqtest
SET PARTNER = N'TCP://192.168.1.1:5021'
GO

主机上执行
ALTER DATABASE zhangjqtest
SET PARTNER = N'TCP://192.168.1.2:5022'
GO


 

-----------

测试同步，生成快昭
CREATE DATABASE zhangjqtest_q ON
( NAME = zhangjqtest_q, FILENAME =
'd:\zhangjqtest_q.ss' )
AS SNAPSHOT OF zhangjqtest
GO

--主体服务器

Down掉,镜像服务器紧急启动并且开始服务

ALTER DATABASE 数据库名 SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS