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…
7 years ago
Troubleshooting
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.…
8 years ago
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…
8 years ago
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…
8 years ago
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…
8 years ago
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"…
8 years ago
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…
8 years ago
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…
8 years ago
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…
8 years ago
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…
8 years ago