Rebuilding a SQL Server Database Transaction Log

"Could you help me, we deleted the database's transaction log file and now that database is stuck in 'Recovery Pending'?" This was a panicked call that I received a few weeks ago. "Sure, no problem" said I, "we'll have to restore back to your last backup" And then things went silent for a while before... Continue Reading →

Sep 26, 2024 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