SQL 2012 Mirroring Illustration (resolution 1418)

Source: Internet
Author: User
Tags failover

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.