Error 112 not enough space on the disk failed a client’s backups at random, even though free space looked fine. The cause was how compressed backups pre-allocate the file. Trace flag 3042 fixed it, and a simple free-space rule of thumb helps.
SQL SERVER – Network Name resource fails to come online in a Windows Server 2008 R2 Failover Cluster
After adding a new disk, a client’s cluster Network Name resource would not come online in a Windows Server 2008 R2 Failover Cluster. Here is what we found.
SQL SERVER – Drive Space Full Due to MDMP Files
A client’s C drive kept filling up, and the transaction log was not to blame. SQL dump files were. Here is what caused this Drive Space Full issue.
SQL SERVER – FIX: Could not connect because the maximum number of 1 user connections has already been reached
A client changed one setting, restarted and nobody could connect: the maximum number of 1 user connections has already been reached. Here is how we got in.
SQL SERVER – Patch Upgrade – Failed to connect to server. Error: 0x80070422
A client’s SQL Server 2008 R2 SP2 patch failed, and the setup logs showed Failed to connect to server, Error: 0x80070422. Here is how we traced and fixed it.
SQL SERVER – How Enable Transparent Database Encryption (TDE) for Database Mirroring?
hey incidentally wanted to enable Transparent Database Encryption (TDE) on their server and wanted me to guide on how to enable.
Msg 15559: Script Level Upgrade for master Failed
Msg 15559 says SQL Server cannot drop the ##MS_AgentSigningCertificate## certificate because a user is mapped to it. The upgrade script then fails with error 912 and the service will not start. Start the instance with trace flag 902, drop the mapped user and the upgrade can finish.