In this blog, I would share my findings of how I identified the cause of failure “Disk full: There is not enough disk space on the volume.”
SQL SERVER – Error 17182: Unable to Initialize SSL Support. The Client and Server Cannot Communicate, Because They do Not Possess a Common Algorithm
Unable to Initialize SSL Support. The client and server cannot communicate, because they do not possess a common algorithm
SQL SERVER – Installation Error: 25641- For target, “package0.event_file”, the parameter “filename” passed is invalid. Target parameter at index 0 is invalid
While installing SQL Server 2012 in a client environment, they faced an interesting error about for target. Here is the information that is taken.
SCHEMA_ONLY vs SCHEMA_AND_DATA for Memory-Optimized Tables
Compare SCHEMA_ONLY and SCHEMA_AND_DATA memory-optimized tables, inspect logging and recovery, and test an isolated offline-online cycle.
SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)
One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s)
SQL Server Cluster Resource in Online Pending Too Long
A SQL Server cluster resource that stays in Online Pending for minutes can be waiting for database recovery. This post reads the cluster events and log lines of one case, finds an 8 minute gap, and traces it to a huge number of virtual log files that a log backup and a shrink fixed.
SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database databasename. CREATE DATABASE is aborted
My 2007 post on Msg 1813, Could not open new database, is still popular. SQL Server expert Jeremy Roe sent an updated script for newer versions of SQL Server.