This article help to How SQL Server Always ON can help to achieve RPO and RTO? OR Achieve three in One Solution using SQL Server Always ON How Always On in SQL Server works? SQL Server Always On is one of the best high availability method started from SQL Server 2012. This can be used … Read more
This article guides, How to resolve ,The log for database ‘TestHA’ cannot be shrunk until all secondary’s have moved past the point where the log was added. How synchronizations works in SQL Server AlwaysON? In SQL Server alwaysON, there are at least 1 or more nodes are part of it. Whenever any data change like … Read more
This Article is about , How to find cause of SQL Server cluster failover or SQL restart? | Find AlwaysOn failover reason from SQL Server logs? Why SQL Server restarted or failover in AlwaysON or SQL Server Cluster? There are planned or unplanned outage in SQL Server. Common causes are SQL Service restart, Server reboot, … Read more
This article some best practices about How to perform Index maintenance of large tables in availability groups? OR Index maintenance in availability groups for 10 TB Database What is index in SQL Server? Index is an object in SQL Server database which can be used to retrieve data faster and improve query performance. Mainly there … Read more
This article about, How to resolve, the server principal owns one or more availability group(s) and cannot be dropped? What is availability group? Availability Groups are a feature in Microsoft SQL Server that provide high-availability and disaster recovery for user databases. They were introduced in SQL Server 2012 as a database-level solution, allowing multiple databases … Read more
This article helps to resolved How to fix Error 9002 alwayson in SQL server? or Resolve Always On availability databases in Recovery Pending or Suspect state in SQL Server Whenever you see Database recovery pending SQL server error in always on in SQL server, SQL database went in to suspect mode or in recovery mode. … Read more
This article describes Creating a SQL Login with SQL Server Availability Groups or How do I create a login in SQL Server Availability Group? Logins in SQL Server: There are 2 types of logins can be created in SQL Server. Login with windows authentication: These users first need to be created in Active Directory and … Read more