健忘症補救株式會社

--在 Principle Server 上先製作 Full Backup 及 Transaction Log Backup

BACKUP DATABASE db_name TO DISK='D:\Temp\db_name.bak' WITH init

BACKUP LOG db_name TO DISK='D:\Temp\db_name_log.trn' with init

--在 Mirror Server 上還原database

--### 還原database ###
RESTORE DATABASE db_name
FROM DISK='D:\db_name.bak' WITH REPLACE, NORECOVERY,
MOVE 'db_name' TO 'E:\SQL-DB\db_name.mdf',
MOVE 'db_name_log' TO 'E:\SQL-DB\db_name_log.ldf'

--### 還原 Transaction Log ###
RESTORE LOG db_name FROM
DISK='D:\db_name_log.trn' WITH NORECOVERY

--在 Principle Server db_name上按右鍵--> Properties --> Mirroring --> Configure Security

--依照Wizard建立 Principle Server, Mirror Server, Witness Server, 最後"Start Mirrioring".

--完成後, Principle Server 的db_name後面會出現(Principal, Synchronized)

--           Mirror Server 的db_name後面會出現(Mirror, Synchronized / Restoring...)