SELECT*

Today i have configured WSFC in the Azure environment after creating virtual machines in the Azure. If i am trying to install Fail over cluster service it is throwing error. But if i do the same from power shell with in the virtual machine it is working. Install-WindowsFeature –Name Failover-Clustering –IncludeManagementTools Test-Cluster –Node Node1, Node2 New-Cluster –Name HADRCLUSTER –Node Node1, Node2 –StaticAddress 10.1.0.10

To day i got the below error in one of my production environments, we have nearly 400 databases on which we have configured Database mirroring, we got the below error on one my databases today while i am trying to fail over to the other server which is acting as a mirror. Failover failed on this database alone and it is throwing the below error. To mitigate this issue we followed the below steps First connect to the principal database in which server that particular database acting as  PRINCIPAL  1) Taken the backup of COPY_ONLY  databases.  2)  Run the below command        ALTER DATABASE DatabaseName        SET PARTNER SUSPEND. After this you could see that database status changed to DISCONNECT. 3) Next again run the below two commands. ALTER DATABASE DatabaseName SET PARTNER RESUME After you ran the above statement you can see database come to PRINCIPAL\SYNCHRONIZED state. 4) Next run below command to do the failover ALTER DATABASE DatabaseName

To day i have configured Point-To-Site configuration on my home machine successfully. Which is connected to SQL Server instance which is there in Azure Virtual Machine. I am not giving here any detailed explanation, but few things which was stopped me to configure Point to Site. Usually we follow the below  step in order to configure point to site connection. Create a ResourceGroup Create a VirtualNetwork Create Subnet Create VirtualNetwork GateWay Create GateWaySubnet Create a Virtual Machine without public ip Create certificates and exports I got a few doubts while i am doing configuration when i am creating Virtual network gate way and point to site configuration. In point-to-site configuration give the below ip 172.16.25.0/24   and tunnel type should be SSTP(SSL) if you are configuring this from home machine. And another thing that you need to remember while creating Virtual Network gateway choose SKU as VpnGW1,gateway type as VPN and VPN type as Route