DECLARE @S1 VARCHAR(MAX),@S2 VARCHAR(MAX),@S3 VARCHAR(MAX),@S4 VARCHAR(MAX)
SELECT @S1 = ISNULL(@S1,'')+'
-----主体服务器备份数据库（完整和日志）
BACKUP DATABASE ['+NAME+'] TO DISK=''\\LYNC09.VL.CN\DB\'+NAME+'.BAK'' WITH INIT
BACKUP LOG ['+NAME+'] TO DISK=''\\LYNC09.VL.CN\DB\'+NAME+'.TRN'' WITH INIT
', @S2 = ISNULL(@S2,'')+'
-----镜像服务器还原数据库norecovery(完整和日志;)
----注意数据文件的路径及数据库所有者
EXECUTE AS LOGIN =''sa''
GO
RESTORE DATABASE ['+NAME+'] FROM DISK=''\\LYNC09.VL.CN\DB\'+NAME+'.BAK'' WITH NORECOVERY
RESTORE LOG ['+NAME+'] FROM DISK=''\\LYNC09.VL.CN\DB\'+NAME+'.TRN'' WITH NORECOVERY
',@S3=ISNULL(@S3,'')+'
/*下述操作也可用向导完成：脚本如下*/
---镜像服务器设置镜像伙伴
ALTER DATABASE ['+NAME+'] SET PARTNER=''TCP://LYNC07.VL.CN:5022''
',@S4=ISNULL(@S4,'')+'
---主体服务器设置镜像伙伴
ALTER DATABASE ['+NAME+'] SET PARTNER=''TCP://LYNC08.VL.CN:5022''
/*
增加见证服务器：
*/
ALTER DATABASE ['+NAME+'] SET WITNESS=N''TCP://LYNC09.VL.CN:5022''
go
'
FROM SYS.DATABASES
WHERE NAME IN('CPSDyn','LcsCDR','LcsLog','Lis','QoeMetrics','RgsConfig','RgsDyn','Rtcab','RtcShared','RtcXds','Xds')
AND recovery_model_desc='FULL'
PRINT @S1
PRINT @S2
PRINT @S3
PRINT @S4
本文转自wangtingdong 51CTO博客，原文链接：http://blog.51cto.com/tingdongwang/1208801，如需转载请自行联系原作者
