Tag Archive


accdb repair access recovery access repair Data Backup Database Data Loss Data Recovery Excel corruption excel recovery Excel tips Excel VBA fix zip Hard Drive mdb repair mdf recovery MDF repair Ms Access outlook outlook contacts outlook recovery Outlook repair outlook VBA pst recovery pst repair Quick Access Toolbar recover access recover excel recover outlook recover PST recover sql Registry Editor repair access repair excel repair outlook repair pst repair zip SQL recovery SQL Server sql server recovery VBA View Settings Word Macro word tips zip recovery zip repair

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 […]

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

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 […]

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 […]