A client’s production database was stuck in suspect state and they could not even drop it. Here is how I helped them drop the suspect database.
What Part of the SQLDump Suggest Database Corruption? – Interview Question of the Week #188
What part of the SQLDump suggest database corruption? A reader asked, and I show the DbccResults tag in the SQLDump text file that confirms it.
Msg 5123: CREATE FILE Access Denied on TempDB After Disk Migration
Msg 5123 with operating system error 5, Access is denied, kept SQL Server from starting on a cluster after a disk migration. TempDB files could not be created on the new drive. Giving the SQL Server service account Full Control on the folders fixes it.
SQL SERVER – Upgrade Blocked: The Specified Edition Upgrade is Not Supported
Upgrading SQL Server 2008 R2 Express to SQL Server 2012 Evaluation failed with: Upgrade Blocked: The specified edition upgrade is not supported. Let me explain why.
SQL SERVER – FIX: Backup to URL Error: Operating System Error 50(The Request is Not Supported.)
My Backup to URL jobs started failing with Operating system error 50 (The request is not supported.). Here are the ERRORLOG messages and how I fixed it.
SQL SERVER – FIX: Error – The Job Failed. Unable to Determine If The Owner Domain\User of Job Job_Name Has Server Access
A SQL Agent job failed with: The job failed. Unable to determine if the owner of the job has server access. Here is how I fixed this error in my lab.
SQL SERVER – Unable to Remove Replication Publication – Could not Delete the Subscription at Subscriber ‘SubServer’ in Database ‘SubDB’
On my broken replication lab, removing a publication failed with: Could not delete the subscription at Subscriber ‘SubServer’. Here is the command that fixed it.