A SQL Server cluster install failed with 0x84cf0003: Updating permission setting for folder failed. Service account rights and folder permissions were fine. The cause was the Audit Object Access policy from a GPO.
Only Two VLFs: Cannot Shrink the Log File Any Further
A log file with only two VLFs cannot shrink any further, and DBCC SHRINKFILE tells you so. The message says the number of logical log files cannot be fewer than 2. Here is the script that reproduces it and the DBCC LOGINFO output that explains it.
SQL SERVER – Information Message: Cannot shrink file in database to xxxx pages as it only contains yyyy pages.
A reader hardcoded 1 GB in my log shrink script and got: Cannot shrink file in database to xxxx pages as it only contains yyyy pages. I explain why it appears.
SQL SERVER – Error 21028 : Replication Components are not Installed on This Server
After I set up AlwaysOn for a client, configuring replication failed: Replication components are not installed on this server. Here is how to fix error 21028.
SQL SERVER – FIX: Msg 15190 – There are still remote logins or linked logins for the server
Dropping a linked server with sp_dropserver failed with Msg 15190: There are still remote logins or linked logins for the server. Here is how to clear them.
Rebuild Log for Msg 1813: Could Not Open New Database
Rebuild log is the way back from Msg 1813, Could not open new database, when the log file is corrupted. SQL Server expert Jeremy Roe sent me an updated script for newer versions. This post walks through his nine steps in order.
Set-ClusterParameter Error: ProbePort Does Not Exist on the Cluster Object
The Set-ClusterParameter error said Parameter ‘ProbePort’ does not exist on the cluster object. I hit it while setting up a probe port for an Always On listener in Azure. Two wrong values in my script were the cause, and fixing both let the script run.