The database cannot be recovered because the log was not restored

A test restore of a SQL Server database had somehow been left in the “RESTORING” state. I attempted to bring the database online with

RESTORE DATABASE db_name;

But I was greeted with…

Msg 4333, Level 16, State 1, Line 1
The database cannot be recovered because the log was not restored.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

To fix you need to drop and restore the database again…

DROP DATABASE db_name;
 
USE [master]
GO
-- Create db again...
CREATE DATABASE [db_name];
-- restore over with usual backup scripts...

Leave a Reply

Current ye@r *