sql server AlvaysnOn辅助副本配置事务日志传送

1.AlvaysnOn可用性改成（异步提交），可读辅助副本改成（是）

2.AlvaysnOn主库备份数据库

backup database hisdb01
to disk=‘\WIN-DFGJNRELU3M\DB_hisdb01\hisdb01.bak’

3.在日志恢复服务器，恢复主库的数据库备份

restore database hisdb01
from disk=‘\WIN-DFGJNRELU3M\DB_hisdb01\hisdb01.bak’
with standby = ‘C:\DATA\hisdb01.log’,
move ‘hisdb01’ to ‘C:\DATA\hisdb01.mdf’,
move ‘hisdb01_log’ to ‘C:\DATA\hisdb01_log.ldf’

4.AlvaysnOn主库备份数据库日志

BACKUP LOG hisdb01
TO DISK = N’\WIN-DFGJNRELU3M\DB_hisdb01\hisdb01_log1.trn’
WITH NOFORMAT, NOINIT,
NAME = N’hisdb01-完整 数据库 备份’,
SKIP, NOREWIND, NOUNLOAD, STATS = 10

5.在日志恢复服务器，恢复主库的日志备份

– 将需要还原的数据库进行脱机
USE master
ALTER DATABASE hisdb01 SET SINGLE_USER WITH ROLLBACK IMMEDIATE

–用standby模式恢复事务日志
RESTORE LOG hisdb01
FROM DISK = N’\WIN-DFGJNRELU3M\DB_hisdb01\hisdb01_log1.trn’
WITH FILE = 1, standby = ‘C:\DATA\hisdb01_log1’,
NOUNLOAD, STATS = 5

6.AlvaysnOn备库配置日志同步