I talking about Entire server is down due to some hard ware issue, which is Passive Node.

as regular practice, SQL Server will load the data in Main memory to improve...

How memory Works in SQL Cluster ?

If active node is fail all the data stored in main memory (Data cache, Buffer cache)

Would it transfer to New Passive node Main...

you mean transaction will rollback on New Passive node and failed on Old Passive Node by using MSDTC ? transaction

can anyone answer for my question ?

EXEC sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

EXEC sp_configure 'xp_cmdshell',1

GO

RECONFIGURE

GO

EXEC XP_CMDSHELL 'net use H: \\foldername1\foldername2\sharedfoldername3'

EXEC XP_CMDSHELL 'Dir H:'

EXEC XP_CMDSHELL 'net use H: /delete'

EXEC sp_configure 'xp_cmdshell',0

GO

RECONFIGURE

GO

yes please

No Its not exact Link. do u have exact link ? if not leave it.

any link for Glenn Berry's DMV diagnostic scripts ?

Our Database size is 2 TB, Based on the Databases Size SQL Occupied RAM Memory ?

Can you please provide Stairways links ?

There is a feature "Automatic fail-over" in "Always on High Availability Group"

Do we need another node (3rd node) for Automatic fail-over for AO HA Group ? or can we implement...

why can't you schedule log backup and overwritten on existing .bak file ? with compression option

you can do it by SQL Script or maintenance plans

Thanks a lot..

1) For testing before implementing in Production, Can we create Always on High Availability Group with 2 nodes (Active to Passive) on Windows 2012 Hyper-V virtual machines ?...

Databases also newly created.

no it is new installation only.