Posted by l0b0 on 08/22/07 08:34

I'm working on a restore procedure for the case where all MDF files
are missing, but the LDF files are all intact. A full backup is done
every 24 hours, and a log backup is done every 3 hours. After
restoring the last full + log backups, is it at all possible to use
the LDF files to recover data from that point up to a newer point in
time?

I've found a post which explains how to do this on SQL Server 2000
<http://groups.google.com/group/comp.databases.ms-sqlserver/
browse_thread/thread/3ef5c7cbc0a83334/f3b0c70811d35ed7>, but step 4
fails with the following error message:
BACKUP LOG cannot be performed because there is no current database
backup.

[Back to original message]