The articles in the blog deals with implementing/Administration/Troubleshooting of SQL Server, Azure,GCP and Terraform I rarely write for a place to store my own experiences for future search but can hopefully help others along the way
About Me
- Rakesh Kumar
- I am MCSE in Data Management and Analytics with specialization in MS SQL Server and MCP in Azure. I have over 13+ years of experience in IT industry with expertise in data management, Azure Cloud, Data-Canter Migration, Infrastructure Architecture planning and Virtualization and automation. Contact me if you are looking for any sort of guidance in getting your Infrastructure provisioning automated through Terraform. I sometime write for a place to store my own experiences for future search and read by own blog but can hopefully help others along the way. Thanks.
Violation of AlwaysOn constraint
================================
Rakesh configures WSFC cluster with two nodes, NODE01 and NODE02. He installs a SQL Server failover cluster instance, fciInstance1, on both NODE01 and NODE02 where N
SQL 2012 setup fails with "Wait on the database engine recovery handle failed in windows server 2008 R2 Cluster"
SQL 2012 setup fails with "Wait on the database engine recovery handle failed in windows server 2008 R2 Cluster"
Remove a Secondary Replica from an Availability Group & Remove a Database from AlwaysOn for Maintenance or Migration
Remove a Secondary Replica from an Availability Group & Remove a Database from AlwaysOn for Maintenance or Migration & Remove primary replica or drop Availability Group for Reconfiguration of AlwaysOn.
A problem occurred when loading the Microsoft SQL Server Management Studio menu.
Issue:-
After SQL Server 2012 Enterprise edition installation, some time SSMS do not invoke and Error comes like
---------------------------
Microsoft SQL Server Management Studio
---------------------------
A problem occurred when loading the Microsoft SQL Server Management Studio menu. To fix this problem, run 'Ssms.exe /resetsettings' from the command prompt. Note: this command resets your environment settings.
After SQL Server 2012 Enterprise edition installation, some time SSMS do not invoke and Error comes like
---------------------------
Microsoft SQL Server Management Studio
---------------------------
A problem occurred when loading the Microsoft SQL Server Management Studio menu. To fix this problem, run 'Ssms.exe /resetsettings' from the command prompt. Note: this command resets your environment settings.
Subscribe to:
Posts (Atom)