AD RMS High Availability (v) RMS database Allwayson

Last Update:2015-04-09 Source: Internet

Author: User

Tags failover

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

(i) Creating a failover Cluster

Add two servers rms-sql01 and rms-sql02 to the domain, the SQL installation step is simple so here is ignoring the SQL installation process, install SQL as usual (this environment uses the SQL 2012 Enterprise Edition template image on Azure. ）。

1. Click "Add roles and features" to begin adding the failover cluster role.

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulr9grwqawaagal5f6kym405.jpg "width=" 634 "height="/>

2. Click "Next"

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/da/wkiom1ulr9ri0nyyaafkwyos6to164.jpg "width=" 634 "height="/>

3. Select the server you want to install and click "Next"

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/da/wkiom1ulr-siw1bdaaglv8r1pl0438.jpg "width=" 635 "height="/>

4. The role remains the default, click "Next"

5. Tick "Failover Cluster" and add the appropriate features.

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/da/wkiom1ulr_nb7qaeaagcysv8zhi269.jpg "width=" 622 "height=" 442 "/>

6. After the tick is complete, click Next

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/da/wkiom1ulsakaxcxjaagdq4rcirc281.jpg "width=" 614 "height=" 435 "/>

7. Click "Install"

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulsa2zxve8aaf1l2ystr0504.jpg "Width=" 616 "height=" 438 "/>

8. Wait for the installation to complete

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/da/wkiom1ulsbfzdi5waafkuu5du70643.jpg "width=" 608 "height=" 432 "/>

The above is the RMS-SQL02 add cluster function operation, rms-sql01 do the same thing.

9. When you are finished adding the cluster role, open failover Cluster Manager and right-click to select Create Cluster

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/da/wkiom1ulsclqpuvfaag2n-xwx9a026.jpg "width=" 601 "height=" 425 "/>

10. Start the Create Cluster Wizard and click Next

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulscrgtcz7aagnngh9zfk401.jpg "width=" 595 "height=" 403 "/>

11. Add two SQL services.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/da/wkiom1ulsc6idlbgaaeoevuid9y537.jpg "height=" 405 "/>

12. Select Run Configuration verification test. Click Next.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/da/wkiom1ulsdfbc_ybaafxtusjcry643.jpg "height=" 405 "/>

13. Start the Cluster Validation Test wizard

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulsdzwebj9aaeuojawzag449.jpg "height=" 405 "/>

14. Select "Run only selected tests" and click "Next"

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/d5/wkiol1ulsynibqhpaae5iiefybc438.jpg "height=" 405 "/>

15. Remove the Tick "storage" because SQL Allwayson does not require cluster storage testing.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/d5/wkiol1ulsy6zycklaaevunrq78c614.jpg "height=" 415 "/>

16. After confirming the error, click "Next" for the cluster verification test.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/d5/wkiol1ulszstvv1_aafgqjofeec983.jpg "height=" 414 "/>

17. Because the environment is built on Azure, the failover feature is not supported, click Finish.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/d5/wkiol1ulszqyubasaafcpify7hq236.jpg "height=" 421 "/>

18. The reason for the error is as follows because there is no dual network card.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/d5/wkiol1ulsz-xupfkaahxf6xepsu421.jpg "height=" 390 "/>

19. Start the Create Cluster wizard

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/d5/wkiol1ulsaidhxexaag-pr4tfmg537.jpg "height=" 438 "/>

20. Add two SQL Servers in

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulsgshgj7taaeiuux57ha836.jpg "height=" 434 "/>

21. Set the name and IP address of the cluster, and subsequent manual changes will be OK.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/d5/wkiol1ulsbhso0vraaegq8yavju058.jpg "height=" 434 "/>

22. Create complete. The cluster quorum configuration is set up later.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/d5/wkiol1ulsbigdhb5aaf1cgh5y-y649.jpg "height=" 439 "/>

23. Change the cluster IP address

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/d5/wkiol1ulsckw4vqoaaifkdcnxao795.jpg "height=" 505 "/>

24. Change the cluster quorum configuration. Right-click "Rmssql"-"more Operations"-"Configure cluster quorum settings".

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulsikqrnmhaaibybva9hc709.jpg "height=" 508 "/>

25. Configure the Cluster Quorum wizard.

26. Select "Add or change quorum witness"

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/d5/wkiol1ulsdfqghswaae_hxlg4yw832.jpg "height=" 431 "/>

27. Set the file share path.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulsjst7oy3aaehslydous711.jpg "height=" 411 "/>

28. The permissions of the shared folder must be rmssql$ read and write permissions.

29. After confirming the error, click Next.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/da/wkiom1ulsj_zvrugaaepq-kwkni353.jpg "height=" 404 "/>

30. Complete the cluster quorum configuration.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulsktskat0aaemod51sc0153.jpg "height=" 394 "/>

(ii) Creation of SQL high availability groups

31. Open the SQL Configuration Management Console and right-click the SQL Server properties.

32. Enable AlwaysOn features.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/d6/wkiol1ulsfexm88zaafcp9_uzh4780.jpg "height=" 553 "/>

33. Change the SQL run account to the domain administrator and use rmsadmin directly

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/d6/wkiol1ulsfqznc-kaagsa97orh4047.jpg "height=" 548 "/>

34. Set up a shared folder, permissions such as, etc. created by the availability group need to be used.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/d6/wkiol1ulsf6wvzj3aafgl-iu8_w813.jpg "height=" 451 "/>

35. Set the recovery model for the RMS database to full

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/d6/wkiol1ulsgxzdu2baaglc3v63m4232.jpg "height=" 431 "/>

36. Backup of the RMS database

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/d6/wkiol1ulshfr77-naajapplbjp4998.jpg "height=" 454 "/>

37. Backup Type Select "Full"

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/d6/wkiol1ulshya6i-6aagm0qdrga8158.jpg "height=" 485 "/>

38. Backup Complete

39. Start the New Availability Group wizard

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/da/wkiom1ulsovwdtnzaae_4s1acnc527.jpg "height=" 533 "/>

40. Select Next

41. Enter the availability group name

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/d6/wkiol1ulskixcgekaadnd0sqj8k532.jpg "height=" 510 "/>

42. Tick the RMS database that meets the criteria

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/da/wkiom1ulsqbs7bhwaaelz-j_sie605.jpg "height=" 428 "/>

43. Click "Add Copy" to add the Rms-sql01, as set.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/d6/wkiol1ulslbwtl45aahvrch8do0883.jpg "height=" 539 "/>

44. The endpoint remains the default setting

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/d6/wkiol1ulslubyyh8aafglrewsl0172.jpg "height=" 535 "/>

45. Backup Preferences Select "Preferred secondary replica"

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulsrryqbgzaahu5u4j35q553.jpg "height=" 536 "/>

46. Create an availability group listener, such as

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/da/wkiom1ulssgiiz4oaahfzwr19iy715.jpg "height=" 542 "/>

47. Select the data synchronization preference as "full" and specify the network share path

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/5d/d6/wkiol1ulsngqp51maagt_enngnc777.jpg "height=" 539 "/>

48. Wait for verification to complete

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/5d/d6/wkiol1ulsnrqpspxaahh9lxgpa4059.jpg "height=" 550 "/>

49. Click "Finish" to complete the creation of the availability group

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/da/wkiom1ulstuhyw65aahyxtnt72k938.jpg "height=" 545 "/>

If creating a high availability group fails, refer to the following command.

To create an [NT Authority\System] account, run the following command in the query window:

Use [master]

CREATE LOGIN [NT Authority\System] from WINDOWS with Default_database=[master]

To grant permissions to the [NT Authority\System] account, run the following command in the query window:

GRANT ALTER any availability GROUP to [NT Authority\System]

GRANT CONNECT SQL to [NT Authority\System]

GRANT VIEW SERVER State to [NT Authority\System]

Reference connection.

https://support.microsoft.com/zh-cn/kb/2847723

50. The High availability group was created.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/5d/d6/wkiol1ulsojtjql_aaf4glqqyw0900.jpg "height=" 466 "/>

This article is from the "Month Missing" blog, please be sure to keep this source http://yueque.blog.51cto.com/4580340/1630207

AD RMS High Availability (v) RMS database Allwayson

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

A Free Trial That Lets You Build Big!

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

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

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

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More