SQL Server Solutions

What to Do If Secondary SQL Server Database in Your Replication Miss Data

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 »

Why SQL Server Returns NULL Info About Drives?

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 »

Why You Are Not Able to Access Database in an Availability Group in SQL Server?

SQL Server Database Recovery, SQL Server Solutions September 11, 2017

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 »