Build a disaster recovery runbook around agreed RPO and RTO, usable backup chains, instance dependencies, clear roles, and restore tests.
FOR JSON Data Types: How bit, Dates and Money Come Out
Your API returns 1 and the client wanted true. Here is how FOR JSON picks a JSON type for bit, dates, decimal, money, binary and NULL, and how to fix it.
SQL SERVER – GetRegKeyAccessMask : Could Not Get Registry Access Mask For Registry Key – SQL Server Cluster
In a two-node SQL Server Cluster, SQL would not come online on one node and wrote no ERRORLOG. The cluster log showed GetRegKeyAccessMask. Here is the fix.
SQL SERVER – How to Fix Error 8134 Divide by Zero Error Encountered
Error 8134 means an expression tried to divide by zero. I choose the intended undefined-result behavior before guarding the division.
How to Attach a Database Without Log File in SQL Server
To attach a database without log file, run CREATE DATABASE with FOR ATTACH_REBUILD_LOG, or remove the missing log in the SSMS Attach dialog. This tutorial builds a demo database, detaches it, and rebuilds the log on attach. It also explains when the rebuild is impossible and what to check afterward.
SQL SERVER – Fix Error – Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512
SSMS backup failed with ‘Cannot use the backup file because it was originally formatted with sector size 4096’. Here is why it happens and the easy fix.
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘upgrade_ucp_cmdw.sql’
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.