1.将简单恢复模式调整为完全备份模式
USE MASTER
GO
ALTER DATABASE [test] SET RECOVERY FULL;

2备份主库上的数据库
BACKUP DATABASE [test] TO  DISK = N'D:\bak\test_20130409.bak' 
WITH  compression,stats,copy_only
GO
BACKUP LOG [test] TO DISK=N'D:\bak\test_20130409.trn'
GO
3.拷贝备份到镜像服务器并还原到正则恢复状态。
restore database [test] from disk=N'D:\test_20130409.bak'
with move N'test' to 'K:\SQLData\test.mdf'
,move N'test_log' to 'J:\SQLLog\test_log.ldf',NORECOVERY,stats

RESTORE LOG [test] FROM DISK='D:\test_20130409.trn'
 WITH NORECOVERY
GO
4.主从服务器上分别创建端点
CREATE ENDPOINT [Endpoint_mirror]
AUTHORIZATION [sqlservice] STATE = STARTED 
AS 
TCP ( LISTENER_PORT=5022 , LISTENER_IP = ALL ) FOR 
DATABASE_MIRRORING ( ROLE = PARTNER );

5.镜像服务器和主服务器设置链接
--set partner on Mirroring
ALTER DATABASE [test] SET PARTNER = 'TCP://hostip:5022';
--set partner on primary
--alter database [test] set partner off
ALTER DATABASE [test] SET PARTNER = 'TCP://mirroringIP:5022';
ALTER DATABASE [test] SET SAFETY OFF --高性能异步模式