Database Solutions

Message Handling Can Affect Your Availability Group Replicas in SQL Server

The state of databases participating in Always On are prone to change due to message handling. A sudden failover might interrupt a large transaction happening in the database that participates in Always On. This will result in a lengthy undo process and database status would be ‘Not Synchronizing’. Error message but no user action needed If your availability group is having hundreds of databases and heavy workload runs on the availability group, a sudden failover will change the status of...

Read more »

How to Scan and Get Mirrored Databases in SQL Server

For setting a SQL Server database mirroring we need two SQL Server instance. These two SQL instances can be on the same machine or on different machine. In this article, we will learn how to get the list of all mirrored databases from our SQL Server environment. Scan for Always On This script would help you to scan your SQL environment and identify SQL Server databases that are part of mirroring. In this script, we would be connecting to each linked server from a Central server. Please do...

Read more »

How to Scan and Get Always On Enabled Servers in SQL Server Environment

Maintaining a SQL Server inventory is very important. Before performing a migration project, the inventory will help a database administrator to get more detail about that server. In this article, we will learn how to scan the entire SQL environment and identify servers on which Always on has been enabled. The Best Always on Availability Groups is considered as the best high availability, disaster recovery feature in Microsoft SQL Server. It is the highly-advanced version of database...

Read more »