SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Powershell script to read Windows 2012 R2 Failover cluster log for Sql

By Mashrur Shuvo,

I was having a hard time to reading the Windows 2012 R2 Failover cluster log from my live server. That is why I just wrote a simple PowerShell script to get the job done for me.  By using id = 1641 I can get the information when my failover occurred.

Open the PowerShell console and type the scripts, put your own server name in the place of “ServerName”. 

Total article views: 745 | Views in the last 30 days: 1