A tempdb mistake left SQL Server unable to start. Here is the error while starting SQL Server, a failed assertion on logFileSize, and the fix.
SQL SERVER – Error: Msg 4305, Level 16, State 1 – The log in this backup set terminates at LSN, which is too early to apply to the database.
Msg 4305 says the log in this backup set is too early or too recent to apply. I build a sample database with backups to show why it happens during a log restore.
SQL SERVER – Unable to Start SQL – Error: SQL Server Could Not Spawn Lazy Writer Thread
Playing with affinity settings, I broke SQL Server startup with error 17120: could not spawn lazy writer thread. Here is what the ERRORLOG showed and how I recovered.
SQL SERVER – Error: Msg 245 – Conversion failed when converting the varchar value ‘Inactive’ to data type int
Mixing text and numbers in a CASE statement can throw Msg 245: conversion failed when converting the varchar value to data type int. Here is why and the fix.
SQL SERVER – FIX – Server principal ‘Login Name’ has granted one or more permission(s). Revoke the permission(s) before dropping the server principal
DROP LOGIN failed with Msg 15173 because the login had granted one or more permission(s) after an AlwaysOn cleanup. Here is how to find and revoke them.
SQL SERVER – Fix – Error: Msg 468, Level 16, State 9, Line 1
Msg 468 says SQL Server cannot resolve the collation conflict between two columns. I explain why it shows up, including with temp tables, and how to fix it.
SQL SERVER – FIX – Export Error – ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
Importing an Excel file with the SSMS Import Wizard failed because the Microsoft.ACE.OLEDB.12.0 provider is not registered. Here is how I fixed it.