Original: SQL 2012 mirroring Diagram (resolution 1418)
1. Environmental preparedness
1.win7+sql 20,122 Machines
such as: 10.58.8.114 login Account testb 10.58.8.96 login Account TestA
2. Create a new two DB instance:
Example: 10.58.8.114 instance name Testb 10.58.8.96 Instance Name TestA
3. Two machines create the same login account and password, and add it to Administrator privileges (resolve error 1418)
4. Set the SQL Server service login account as the current administrator account (both the principal and the mirror server are set) (fix error 1418)
5. Ensure that both machines can ping and the ports are interoperable
Ready to work, mirroring synchronization is implemented below
2. Implement mirror 96 body 114 mirror
1. Create a database (principal and mirror server) testm
2. Principal server Backup database (full and transaction logs)
3. Mirror server Restore principal backup
After the restore is complete, you can see the following status:
4. Configuring the principal image 96
Right-click Databases >> tasks >> mirroring
Select Configuration Security
Next
Whether the witness server is included, not discussed, no
Principal instance
Mirrored instances
、
Service Account
Complete
Start mirroring
You can see the following when you finish
Principal server
mirror server
3. Failover
Principal server, specifying database right-click Tasks >> Mirroring >> failover
At this point we can see the principal server as follows:
The mirror server is as follows:
The Monk of Http://www.cnblogs.com/woxpp/p/4293187.html: the Buddha of Buddhism
Do not discuss the witness server and certificate, if there is a problem welcome correction
SQL 2012 Mirroring Illustration (resolution 1418)