Category: Troubleshooting

disk compression 0

Fix SQL Server Installation Error: Attributes do not match

Last week I was working on SQL Server installation where i got this error Attributes do not match. Error details of that issue are given below: Microsoft.SqlServer.Configuration.Sco.DirectoryAttributesMissmatch: Attributes do not match. Present attributes (Directory, Compressed, NotContentIndexed) , included attributes (0),...

event id 833 0

Fix Event ID 833: SQL Server has encountered 32 occurrence(s) of I/O requests taking longer than 15 seconds to complete.

Last week, we found some slowness in one of our database server. When we analyzed the database server, we found poor disk performance where I/O requests taking longer than 15 seconds to complete. Below messages were logged multiple times in error...

error 3023 1

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 error details are given below: Shrink failed for LogFile ‘Logfile_Name”. Backup, file manipulation operations (such as ALTER DATABASE ADD FILE)...

Error 976 0

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 Group configuration. The details about error Microsoft SQL Server 976 that he was getting is given below. Cannot connect to...