SQL 2012 Mirroring Illustration (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)