After a cluster failover, SQL Server would not start on Node2 because upgrade step ‘upgrade_ucp_cmdw.sql’ failed. Here is what the ERRORLOG showed.
SQL SERVER – SSMS Error During Restore: No Backupset Selected to be Restored
Restoring a SQL Server 2008 backup in SSMS 2012 gave ‘No backupset selected to be restored’. A reader’s question and what causes this restore error.
SQL SERVER – Backup to URL Fails in Azure Resource Manager (ARM) Deployment Model with Error – (400) Bad Request
Backup to URL failed with (400) Bad Request on storage created in the Azure Resource Manager model. Here is why and how my client got it working.
SQL SERVER – False Error – Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.)
BULK INSERT said ‘Operating system error code 5 (Access is denied.)’ but that was not the real problem. A repro of this misleading error and the real cause.
SQL SERVER – A Timeout (30000 milliseconds) was Reached While Waiting for a Transaction Response from the MSSQLSERVER
Event ID 7011: a timeout was reached while waiting for a transaction response from MSSQLSERVER. It happened when my client expanded an Oracle linked server.
SQL SERVER – Installation Fails With Error – A Constraint Violation Occurred
SQL Server cluster Installation Fails with ‘A constraint violation occurred’ as the network name won’t come online. I’ve fixed it for 10 clients.
SQL SERVER – Creating a Copy of Database in Azure SQL DB
A client wanted to tune a slow query on a copy, not on production. Here is how to create a copy of a database in Azure SQL DB and work on it safely.