Take a tail-log backup before an approved restore, understand NORECOVERY and damaged-database options, and rehearse the full recovery chain.
SQL SERVER – FCB::Open failed: Could not open file Path for file number 2. OS error: 5(Access is denied.)
SQL Server would not start after a client moved database files from C to D drive: FCB::Open failed with OS error 5, Access is denied. Here is the fix.
Moving TempDB to New Drive – Interview Question of the Week #077
A 1 AM call: TempDB was full on the C drive. Here is the popular interview question on moving TempDB to new drive, with the steps I use.
SQL SERVER – Fix Error – 948 A downgrade path is not supported. The database cannot be opened because it is version.
Attaching a database gave me Error 948: a downgrade path is not supported. Here is why a database from a newer SQL Server version won’t open on an older one.
SQL SERVER – Identifying InMemory OLTP Hash Collisions
A follow-up to my post on hash collisions: DMV queries that help with identifying InMemory OLTP Hash Collisions caused by a poorly chosen bucket count.
SQL SERVER – SQL Profiler vs Extended Events
SQL Profiler or Extended Events? I compare how each one works, why SQL Trace adds overhead on a busy server, and why Extended Events is my choice.
SQL SERVER – FIX – Linked Server Error 7416 – Access to the remote server is denied because no login-mapping exists
Linked Server Error 7416: access to the remote server is denied because no login-mapping exists. What the message means and how to fix the login mapping.