After patching, SQL Server would not start. The SSIS hotfix script failed because database SSISDB is enabled for Database Mirroring. Here is the fix.
SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name
A reader used HOST_NAME() in a logon trigger to limit access. Here is why that is risky, and why Logon Triggers can lock everyone out if you are not careful.
SQL SERVER – Steps to Migrate Cluster Storage from Old Disks to Newly Attached Disks
Here are the steps I used to migrate Cluster Storage for a SQL Server 2014 cluster from old IBM disks to new ones: data, log, TempDB, MSDTC and quorum.
SQL SERVER – FIX: Error: 5511 – FILESTREAM’s file system log record under log folder is corrupted
Error 5511 says the FILESTREAM file system log record under the log folder is corrupted. Here is how I got the database back online.
SQL SERVER – Upgrade Error – ALTER DATABASE Statement Not Allowed Within Multi-statement Transaction
A failed SQL Server 2014 SP2 left the service down with: ALTER DATABASE statement not allowed within Multi-statement Transaction. Here is how to fix it.
SQL SERVER – FIX: Error 14001: The Application Has Failed to Start Because its Side-by-side Configuration is Not Correct
A Jr. DBA’s SQL Server service would not start: Error 14001, the application’s side-by-side configuration is not correct. Here is how we found the cause.
SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (404) Not Found
Error 3271 during backup to URL has many causes. After the 403 and 400 versions, here is what causes the (404) Not Found error and how to fix it.