Corrupted Log - Can't Attach Database
Posted on 2006-06-21
In SQL 2000, sp4 we are now getting this error when trying to attach this 10gb database.
Msg 9004, Level 21, State 10,
An error occurred while processing the log for database 'mydb'
Initially when the server was rebooted, Enterprise Manager indicated that the database was still being loaded (after) and an administrator tried to detach the database to try reattaching, which may have corrupted the log and is where we are at now. The previous night's backup was missed, so we may have to go back 2 days if we need to restore from tape.
We tried using the sp_attach_single_file_db to bypass the log if it was corrupted, but the result is:
Msg 1813, Level 16, State 2, Server MyServer, Line 1
Could not open new database 'sgla'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'D:\SQLData\mydb_log.ldf' may be incorrect.
Any suggestions other than restore from tape?