Replication is a widely-used SQL Server concept for maintaining copies of a database at different locations. The major advantage with replication is the Object level control. Though it is easy to set up, an unhealthy replication status might take time to fix. In this article, we will learn how to fix secondary databases that are out of sync.
Reasons
When your subscriber is not receiving data from the publisher, any one from the below list could be the root cause
The published article has...
Read more »
When you are trying to get information about drives on your server you might see that SQL is returning NULL values instead of actual values. In this article, we will understand the reason for such NULL values and how to prevent those.
Dynamic management function
sys.dm_os_volume_stats is a SQL Server dynamic management function with which you can
get your server’s volume information
attributes of server’s drives
status of free space
This dynamic management function requires...
Read more »
Failover Condition Level determines when a failover should occur. This applies to SQL Server Always on Availability Group and to the SQL Server Failover Cluster Instances. Based on the failover condition level, you might not be able to access databases participating in Always On.
Policy to failover
For an availability group, automatic failovers are controlled by failover policy. With these policies, we can attain the highest level of control on the conditions that trigger a failover. In your...
Read more »