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 (

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

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”

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


Eng.Mostafa Elmasry

Database Administrator

Enable Network Discovery Server 2008 R2


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

Difference between MBR and GPT in hard disk

Difference between MBR and GPT in hard disk

MBR:Master Boot Recorded

  • This option found in all operating  System
  • This option found if your disk type is basic not dynamic
  • You can setup any operating system 64bit or 32bit
  • You can make Dual booting because you have option make partition as active so you can setup more than one operation system in this hard
  • In windows XP  you can create 4 primary partition
  • In windows vista,7,2003 you can create 3 partition (Mandatory) and 128 logical partition
  • In windows 2008 can create 3 partition (Mandatory) and unlimited  logical partition
  • Support 3 file system Fat 16 , Fat 32 ,  NTFS
  • Mix mum Size of the partition is 2TB

GPT :GUID Partition Table

  • This option found in All operating system expected XP so in xp all hard disks if it basic it will be MBR
  • This option found if your disk type is basic not dynamic
  • Any operating system can running in this partition but must be 64bit if it 32bit will not running
  • You can’t make Dual booting because you don’t have option make partition as active like in MPR so you can’t setup more than one operating system
  • In windows 7,2003,2008 you can create 128 primary partition
  • You can’t create logical partition
  • Support one file system NTFS only
  • Mix mum size of the partition is 256 TB

Server Core in windows server 2008

What is Window Server core ?

Server Core is a minimal server installation option for computers running on the  Windows Server 2008 operating system or later. Server Core provides a low-maintenance server environment with limited functionality.

Server Core Requirements?

Windows server 2008 or later version .

Roles cans server core run .

Active Directory domain services (AD DS) (including Read only domain controllers RODS)

Active directory lightweight directory services (AD LDS)

DHCp Server

DNS Server

File Services

Print Services

Streaming Medias Services

Web Server (IIS)