The Mirroring and Transaction Log Shipping options were missing in Database Properties for my freshly created database. Here is what caused it and the fix.
Operating System Error 5 on Backup: Fix Access Denied
Operating system error 5 means Windows refused the SQL Server service account access to a backup folder. This post reproduces the error, shows how to find the account with a query, grants the permission, and explains the look-alike errors for missing paths and mapped drives.
SQL SERVER -Fix Error – Cannot open backup device. Operating system error 5(Access is denied.)
Fix the backup error Cannot open backup device, Operating system error 5, Access is denied: common causes and the solution that worked for me.
SQL SERVER – FIX: Error 5161 – An Unexpected file id was Encountered
While building a tempdb demo, SQL Server would not start and ERRORLOG showed Error 5161, an unexpected file id was encountered. I explain what caused it.
SQL SERVER – FIX – The term ‘Invoke-Sqlcmd’ is not recognized as the name of a cmdlet
My weekend PowerShell learning hit an error: the term Invoke-Sqlcmd is not recognized as the name of a cmdlet. Here is why it happened and the fix.
Msg 230: A Column Level GRANT Overrides a Table DENY
A column level GRANT overrides a DENY on the whole table in SQL Server. A friend challenged my earlier claim that DENY always wins, so I built a repro. The granted column works, and every other column raises Msg 230.
SQL SERVER – Fix – Msg 230, Level 14, State 1 – The SELECT permission was denied on the column of the object , database , schema
Hide a sensitive column like SSN with GRANT and DENY, and users who query it get Msg 230, SELECT permission was denied. Here is a simple walk-through.