Availability Group Database Reports Not Synchronizing / Recovery Pending After Database Log File Inaccessible

  You may find that one or more availability group databases is reported ‘Not Synchronizing / Recovery Pending’ on the primary replica or ‘Not Synchronizing’ on one of the secondary replicas. Despite this, your availability group replicas report they are in the primary role or secondary role, This may occur if SQL Server is unable…


Two Vantage Points

I just returned to Microsoft after a six-year adventure at a startup, BlueMetal. It was a great experience, but I was ready for a change, and I was fortunate to secure a great position as a Partner Technology Architect in Microsoft’s new One Commercial Partner (OCP) organization. I’m thrilled! Now that I’m back, I’m able…


Securely erase physical drives with dban and Hyper-V

I’m writing this between jobs – I’ve left BlueMetal, and haven’t started at Microsoft yet. I’m using this time to do a deep clean on my home office, and I’ve come across a number of hard drives that need disposal. But how to do so securely, so data can’t be recovered? And how can I…


Filter content in ERRORLOG log file過濾log檔案的內容

Filter content in ERRORLOG log file 過濾log檔案的內容 當你在Troubleshooting調查一個錯誤與問題時,如果ERRORLOG有大量不需要的紀錄,你可以使用以下方法來過濾。PS.當然如果你使用SSMS UI介面也是可以過濾,但用Command速度比較快一點。   1.Create a exclude text file(E:TempLogexclude.txt) with the contain below. 建立一個文字檔,填入要過濾的關鍵字,例如以下文字(每一行為一組關鍵字) Error: 18456 Login failed for user 2.Start a Command Prompt as an Administrator and run the command below. 執行以下命令產生過濾後的ERRORLOG檔 type E:TempLogERRORLOG | findstr /i /v /g:E:TempLogexclude.txt > E:TempLogERRORLOG_Filtered.log Reference: Findstr https://technet.microsoft.com/en-us/library/bb490907.aspx