Configure always-on mode for SQL 2016 for SharePoint 2016 (iv)

Above me, we have deployed all of SQL Server 2016

Then there is no problem with the highly available back-end support services for SharePoint 2016.

Next, when you configure SharePoint, you only need to configure the primary database properly.

See http://horse87.blog.51cto.com/2633686/1873525

Then there will be some children's shoes will think, that is not the case? SQL will be able to wash their hands, a big mistake, in fact, in the future need to get a lot of things.

Although we now have the SQL always on high-availability mode, but not in the future production, we can do all the tasks of 100% full automation, one of the most important thing that we need to manually complete the operation is:

manually add the database to the High Availability Group database , allowing it to replicate to the secondary database to ensure future data switchover.

So let's see how to do this Add.

First open the DB instance from the primary database

After you have just installed SharePoint and configured a response for the application service, the approximate content should look like this

650) this.width=650; "width=" 446 "height=" 558 "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; "alt=" image " Src= "Http://s3.51cto.com/wyfs02/M00/8D/90/wKiom1ihf7qQOjr4AAKSQkZzXlQ369.png" border= "0"/>

At this point, we're going to have to sift through it, yes! Manual filtering, whose purpose is to find out which databases you need to replicate.

Then select the availability group that you created earlier, right-click on the availability database , select Add Database

650) this.width=650; "Width=" 529 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M00/8D/8E/wKioL1ihf7uRrgh-AAG9u0PYPYg243.png" border= "0"/>

The system will pop up the Add Database Wizard, click Next

650) this.width=650; "Width=" 534 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M00/8D/90/wKiom1ihf72i2j8eAAH-6hXEQTI202.png" border= "0"/>

Because I have added a lot of databases in my environment, so I will see a lot of gray tick, we find a new database, ready to add.

The first time you join the availability database, you need to do a full backup of the database, or there will be a warning error.

, we have done a full backup of the database, so to meet the added demand, we directly tick on, click Next

650) this.width=650; "width=" 446 "height=" 497 "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; "alt=" image " Src= "Http://s3.51cto.com/wyfs02/M01/8D/8E/wKioL1ihf-OSQOYGAAH-GcPCGxk171.png" border= "0"/>

This step is not unfamiliar to everyone, in the last article, we specifically on the secondary database to create the country this synchronization folder

650) this.width=650; "Width=" 533 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M02/8D/90/wKiom1ihf-SjEVntAAHLTb2jlB8263.png" border= "0"/>

This time, the system will automatically find all the secondary database, because I have only one here, so only a list, production, as needed, here can be more than one.

Then click the Connect button on the back

650) this.width=650; "width=" 532 "height=" 497 "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; "alt=" image " Src= "Http://s3.51cto.com/wyfs02/M02/8D/8E/wKioL1ihf-WR-znNAAEjlRToztM902.png" border= "0"/>

650) this.width=650; "Width=" 571 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M00/8D/8E/wKioL1ihf-awYfMRAAGzsYEORLU016.png" border= "0"/>

The system will automatically fill in the account running the service, click Next

650) this.width=650; "width=" 722 "height=" 352 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M02/8D/90/wKiom1ihf-fALCixAAGMQxyV4U4233.png" border= "0"/>

The system passes verification, click Next

650) this.width=650; "width=" 729 "height=" 361 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M02/8D/8E/wKioL1ihf-jDGa0FAAHIQ8VM-do486.png" border= "0"/>

System review, continue to the next step

650) this.width=650; "width=" 729 "height=" 363 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M00/8D/8E/wKioL1ihf-nTSQ0QAAFkBjKqx3w822.png" border= "0"/>

Wait for the replication process to complete

650) this.width=650; "Width=" 533 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M01/8D/8E/wKioL1ihf-rRY-sHAAFMtWbUgZE327.png" border= "0"/>

When the copy is complete, click Close

650) this.width=650; "Width=" 534 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M02/8D/90/wKiom1ihf-uhk-MtAAFQK__GGhA172.png" border= "0"/>

At this point, we can find the database we just added in the availability database.

650) this.width=650; "Width=" 510 "height=" 219 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M00/8D/90/wKiom1ihf-zjNZcXAADJfGrphlY686.png" border= "0"/>

Then, below the database tree in the SQL home page, you can see that the database has been added with the synchronized typeface

650) this.width=650; "Width=" 441 "height=" 226 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M01/8D/90/wKiom1ihf-2R8-JlAADJ4n05xFg512.png" border= "0"/>

This allows us to complete the addition of a new availability database.

If you need to delete, it is also very simple, if on the primary database, only need to right-click the database in the list of availability databases, choose to remove from the availability database

650) this.width=650; "Width=" 536 "height=" 468 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M00/8D/90/wKiom1ihf-7ivJmNAAK8j_ck4pw902.png" border= "0"/>

If you are on a secondary database server, the options are different, just delete the database files on the secondary database server

650) this.width=650; "Width=" 603 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M00/8D/8E/wKioL1ihf_Cw9N7GAAJL3Z3KQeI935.png" border= "0"/>

Click here, and then you need to manually delete the database list manually. Note The database file size now.

650) this.width=650; "width=" 724 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M01/8D/8E/wKioL1ihf_PynCpiAAOYzkPM2dg364.png" border= "0"/>

Right-click to delete

650) this.width=650; "Width=" 342 "height=" 340 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M02/8D/8E/wKioL1ihf_TzP87vAAFQ8tH-z5k700.png" border= "0"/>

Then confirm that it is the secondary database server, and then click OK

650) this.width=650; "Width=" 557 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M02/8D/8E/wKioL1ihf_WjJX1BAADuAARC9fs562.png" border= "0"/>

As you can see, the disk space is now completely released.

650) this.width=650; "width=" 724 "height=" 497 "title=" image "style=" border-right-width:0px;background-image:none; border-bottom-width:0px;padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; " alt= "image" Src= "http://s3.51cto.com/wyfs02/M00/8D/90/wKiom1ihf_ejUx9cAAOgqE0eB88927.png" border= "0"/>

This article is from the "June Ma Run Space" blog, be sure to keep this source http://horse87.blog.51cto.com/2633686/1897382

Configure always-on mode for SQL 2016 for SharePoint 2016 (iv)