To remove extra log file members, SQL Server needs the files to hold no active log. When one does, ALTER DATABASE REMOVE FILE fails with Msg 5042. This post builds a database with two log files, reproduces the error, shows which VLFs keep the file busy and frees it with log backups. It also explains why the file stays offline until the next log backup.
How to Solve Error When Transaction Log Gets Full? – Interview Question of the Week #272
Question: How to Solve Error When Transaction Log Gets Full?
Answer: This was a question I was asked in the recent Health Check.
Configuration Manager WMI Error: Cannot Connect to WMI Provider
A Configuration Manager WMI error blocks SQL Server Configuration Manager with the message that it cannot connect to the WMI provider. This is a second way to fix it, using mofcomp with the file for your SQL Server version. If mofcomp does not succeed, my earlier post has more steps.
Setup Error 0x86D80018: No More Endpoints Available From the Endpoint Mapper
Setup error 0x86D80018 stopped a SQL Server 2016 to 2017 cluster upgrade when the client patched the second node. The Next Step in the setup summary named an uninstall command. Running it, then rebooting both nodes, let setup finish.
Msg 3254: The Volume on Device Is Empty During RESTORE
Msg 3254 says the volume on a device is empty, followed by Msg 3013, RESTORE DATABASE is terminating abnormally. A client’s DBA hit it during a restore. In my lab, a text file passed off as a backup gave the same error, and the file size told the story.
Error 9002: Transaction Log Full Due to REPLICATION
A transaction log full due to REPLICATION put error 9002 in a client’s ERRORLOG. The database showed no replication at all. The cause was a leftover publication with no subscriber, and here is how we cleared it and shrank the log.
Msg 1842: File Size Cannot Exceed 2147483647 Pages
Msg 1842 appeared when a client’s data file reached the 16 TB limit, 2147483647 pages of 8 KB. Their SQL Agent job kept failing with a full filegroup message. The fix is to add another data file, or to free space or add a log file for the log.