Who’s Updated My Rows?! Interrogating the Transaction Logs

I'm pretty much positive that we've all been here at one time or another. We're sitting at our desk watching Klaus' latest SQL Quickie when a red faced colleague comes marching up to our desk and splutters out, in their rage "Someone's updated all my rows, can you find out who did it?". Now usually,... Continue Reading →

Sep 4, 2017 1

Database in ‘Recovery Pending’ After Transaction Log Backup

Here's a little issue that I came across last week and I thought I'd share my investigations with you. Users started to report that a database was inaccessible and when I had a look, sure enough the database was in 'recovery pending' state. That's odd, a database usually only goes into 'recovery pending' state at... Continue Reading →

Jun 14, 2017 2

Up ↑

Tag: transaction log

Who’s Updated My Rows?! Interrogating the Transaction Logs

Database in ‘Recovery Pending’ After Transaction Log Backup

David Fowler

Adrian Buckman

Archives

Follow me on Twitter

Recent Posts From The Undercover DBAs