the cluster resource is configured to run a seperate monitor



 

Requirements to start SQL Cluster installation

Copy  SQL software and SP   in both nodes
Make sure you login by  Service Account and installation by service account
Service Account Permission:
Local Admin, Full control, Creating computer objects(MSDTC  + SQL Cluster)
2 computer objects(MSDTC + SQL Cluster) should be created and disable
Windows cluster should have full control on SQL Cluster

Both  windows boxes(Nodes) should be same version and edition

Log in by Service Account in  both Nodes verify permission (Local Admin + Full ctrl)
Windows cluster name and IP
Quorum is installed in Q Drive
M Drive is available for  DTC
Shared disks is online , available , right name and able to failover
Run below command to verify available resource

cmd > cluster res

Moving Available Storage from Node1 to Node2(cmd run as administrator)

cluster group "Available storage" /move

Verify Available Storage Moved or Not-----------

cluster group "Available storage" /move: <NodeName>

Moving Quorum

cluster group "cluster group" /move: <NodeName>

C and F both dirves are in both nodes

Verify  MSDTC VIP and SQL Cluster VIP
VIP and object  name should be verified  in below command
cmd  > nslookup  <VIP>
VIP should not showed in below command
cmd > arp -a
Verify Networks
Run cluster validation report
Verify report properly

=======================================================

Add all features + Roles in both nodes
Install DTC
Test Failover Failback test for DTC

Again run cluster  Validation Report

Move all resources in Node1

===========================

Start SQL Cluster Installation

How can create SQL Server Port ?

Step 1:

Run > services.msc > Start Windows Firewall

Step 2:

Control  Panel  > System and Security > Windows Firewall > Advanced Setting  

Step 3:

For inbound rule:

 Inbound Rules > New Rule > Port >Specific Local Port : 1544(Example) > Next .......

 

Step 4:

For outbound rule:

Outbound Rules > New Rule > Port >Specific Local Port : 1544(Example) > Next .......
Step 5:
Change SQL server port to 1544(as example)

Step 6:
Restart SQL Server Service

Test/Validation:
Step 1:
Connect SQL Server using <InstanceName>,<port>

Step 2:
 Run below command in cmd to find out all ports:netstat -anr
Run below comman in cmd to find out used port:netstat -na|find "LISTEN"

How can get SQL Server configuration Manager if it is disappeared ?

Method 1:

Go to  "Search for Program Files"  and write down

SQLServerManager10.msc------------- For SQL 2008/2008R2

SQLServerManager11.msc--------------For SQL 2008/2012

 

 

Method 2:

Go to "Search for Program Files" and write down

MMC > File > Add/Remove Snal-in> SQL Server Configuration Manager > Add > OK> Console Root > Expand SQL Server Configuration Manager

 

How do you move storage between nodes

Moving Available Storage from one node to another node:
cmd (Run as administrator) >cluster group "Available storage" /move

Verify Available Storage Moved or Not:

cluster group "Available storage" /move: <Node _Name>

Moving Quorum:

cluster group "cluster group" /move: <Node_Name>

How do change SQL Server Database default Backup Path ?

Run> regedit >HKey_Local_Machine\Software\Microsoft\Microsoft SQL Server\MSSQL.10_50.<InstanceName> /MSSQLServer/BackupDirectory

How can See cluster Resorce Status if Failover Cluster Console does not work ?

cmd(Run as Administrator)
cluster res

How do you set up collation during sql installation ?

How do you find out SQL Server running on Physical or Virtual Platform ?

Run Select @@version,  Hypervisor means Virtual server


For Physical Server/Platform/Box:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)   Jun 28 2012 08:36:30   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

For Virtual Server/Platform/Box:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)  (Hypervisor)