Troubleshooting

Fix SQL Server Error 3023: Shrink failed for LogFile “Log File Name”

Today, I got below Microsoft SQL Server error 3023 when I was trying to manually shrink a log file. The…

SQL Server Alwayson Error 35250: Joining database on Secondary Replica resulted in an error

We got this Microsoft SQL Server error 35250 while configuring Alwayson Availability Group on one of the SQL Server Instance.…

Fix SQL Server Error 976: Cannot connect to Secondary Replica of AlwaysON Availability Group

Today an application user has reported that he is not able to connect to the secondary replica of AlwaysOn Availability…

Fix SQL Server Error 19471: Listener issue that came during Configuring SQL Server AlwaysOn Availability Group

I had an AOAG configuration between two replicas that i have deleted in order to perform some activities. I was…

Why is table row count showing incorrect value in sys.partitions or in DMV sys.dm_db_partition_stats

Last week, I had a requirement to check the row counts of all the tables present in a database. I…

How to Fix SQL Server Configuration Manager Issue: MMC could not create the snap-in

We had successfully installed SQL Server on this server but we have received error "MMC could not create the snap-in"…

Fix SQL Server Error 15433, Level 16, State 1: Supplied parameter sid is in use

I got Microsoft SQL Server error 15433 during fixing orphaned users on a SQL Server Instance where AlwaysON Availability Group…

Fixing SAP Connectivity issue after AOAG Automatic failover

We have Alwayson Availability Group configuration for our SAP systems. We faced SAP connectivity issue when application team tried to…

Fix SQL Server Error 15170: Login owns one or more Agent Jobs

I got Microsoft SQL Server error 15170 while removing a SQL Server login on one of SQL Server Instance. Microsoft SQL…

Fix SQL Server Error 15434: Could not drop login ‘Domain\abc’ as the user is currently logged in

Generally, Microsoft SQL Server error 15434 appears during removing a SQL Server login. This error generates when you try to…