Mustafa EL-Masry HA Clustering

Create SQL Server HA and DR using FCI and AOAG


One of the most tricky subject for any SQL Server DBA or SQL server consultant How to build HA ( High Availability ) it is not something Complex, but it need to be list down all of the points and the requirements before going for this project and when we talk about High Availability We should consider two technology FCI (SQL Server Failover Cluster) and AOAG (Always on High Availability Group) both technologies will give you the same feature ( High Availability ) to save your DB from any disaster  can be happened in your DB center , As you know AOAG is new technology released with SQL Server 2012 and Microsoft added more features on it in SQL Server 2016, 2017 and 2019 as well . So really I recommend it for HA solution. Also, it will give you the availability to split your transaction between multiple instance one as RW (Read-write) it is called Primary, and the other instance will work as R (Read only), and it is called secondary server.

Now I leave you with the training video to know How you can build SQL Server HA and DR using FCI and AOAG


Training video published by Mr. Musab Umair  Microsoft SQL Server DB Consultant you can follow him on his LinkedIn account (https://www.linkedin.com/in/musabumair/)

Keep following our community to know all of the new technologies and features in SQL Server

Andrew Jackson General topics, Windows Server 2008 R2

Steps for Creating System Stored Procedure In SQL Server 2008 R2


In our previous discussion, we have discussed about transaction log corruption and backup in SQL Server. Now, in this article we will know the steps for creating system stored procedure in SQL Server 2008 R2.

Organizations where SQL Server system is used for database storage and maintenance, projects with 1000s of database tables and stored procedures are common to find. Adding even a single parameter to an existing stored procedure can straightaway put an impact on a large number of other stored procedures or database tables as they are called from them. Moreover, Continue reading “Steps for Creating System Stored Procedure In SQL Server 2008 R2” →

Mustafa EL-Masry HA Clustering

Cluster Firewall issue – An item with the same key has already been added


Problem :

When I Prepare the Test Environment to the SQL Server Clustering  Under Windows Server 2008R2 Clustering I get this issue :

Clutser validation Error

After I Create the Cluster must be make validate the Configuration when I check this Configuration I get this issue Validate Windows Firewall Configuration in the detail of the error An item with the same key has already been added

Reason of the problem :

This is typically because the NIC GUID is duplicated between cluster nodes. When I won’t to create 3 Virtual machine (Cluster-PC , Node 1 , Node 2 )

I Create the First Virtual machine and take it Twice copy this is the issue because when I make Copy the Node 1 and Node 2 Created with the same Physical Address (MAC IP) so the Conflict in this area

the first solution came to my brain it’s I will Format Node 1 and I will install it from the first (Windows) but I Check more time to another Solution and I defected good Solution by Asking my friend System Administrator Eng.Hamada Abdelkader

Solution :

1- open the Run

2- Write this Command (sysprep)

3- Enter

this Command is System preparation it will male  preparation to the network after this Command finish I Check the mac IP very good new Address and I run the Validate Configuration for the Windows Cluster again and it successful 100%

Thanks For Eng.Hamada Abdelkader

Regards,

Eng.Mostafa Elmasry

Database Administrator

Mustafa EL-Masry Windows Server 2008 R2

BgInfo v4.16


If you manage multiple computers you probably need BGInfo. It automatically displays relevant information about a Windows computer on the desktop’s background

Download BgInfo software

http://technet.microsoft.com/en-us/sysinternals/bb897557

 

 

Mustafa EL-Masry Network

Enable Network Discovery Server 2008 R2


Problem

When you try to Enable Network Discovery in Server 2008 R2 After you have enabled this it simple turns off again so you need to enable the following services

Services you must enabled it before enabled Network Discovery :

1- DNS Client

2- Function Discovery Resource Publication

3- SSDP Discovery

4- UPnP Discovery

The ways to Enable this Services :

Way No 1

Open Run then Write CMD then Write this Statment

  • net start “DNS Client”
  • net start “Function Discovery Resource Publication”
  • net start “SSDP Discovery”
  • net start “UPnP Discovery”

Way NO 2

Open Start Menue / Administrative Tools / Services / Then Select your Serives