Tuesday, December 26, 2017

SQL AlwaysOn-Skype For Business- II

In first post we mainly focused on Windows Clustering and configuration, which is the critical part, in this part i will describe SQL installation and configuration in details.

Installing SQL Server

Mount SQL server ISO or put DVD and launch the SQL server installation center and select "New SQL Server fail-over cluster installation"

SQL Server Setup files will verify the system

Setup support rules identify problems
Here you need to select "SQL Server Feature Installation"

Now we have to select the features
Here we have select the instance or default or new instance and Instance root directory
we have select Server Configuration and select authentication mode
here is the Installation progress status
Installation has been completed and we can view the reports 

Now Launch SQL Server Configuration Manager >Click SQL Server Services > Right Click SQL Server (Instance Name) > Properties > AlwaysOn High Availability Tab

Once you select the "Enable AlwaysOn Availability Groups" you will get the warning click "Ok"
Time to restart the SQL Server Agent services

Skype for Business Deployment

We now move on to the deployment process for the Skype for Business Back End Database, as we already completed the All Front End Servers have been built with prerequisites, Skype for business Management Tools are installed and Skype for business topology has not to be defined

Now press New, give the SQL server FQDN and select the Named Instance, in my case it is default

Click High Availability Settings, now we can see the SQL Server FQDN filed has now changed to SQL Server Availability Group Listener FQDN and specify the primary SQL Server within the SQL Server FQDN field

Once complete publish the topology.

Configure Skype for Business Databases for SQL AlwaysOn Availability Group

Now Launch SQL Server Manager
Connect the SQL database and create New Database for high availability

Give the Name etc.
Here you can see the Newly created Database, Right Click and open the properties > Select Option > Change Recovery Model from Simple to Full and repeat the process QoEMetrics

Now we need to backup the databases within SQL Management Console, right click the Database SfBTestDB>Task>BackUp
Verify the all settings and Click on Ok.

Here you will get the confirmation

If you have the more Database you have to repeat the same process, here we have completed converting the Database to Full Recovery mode and backed up.

Next post we will start with configure AlwaysOn High availability.

Thank you!

Happy Learning!