DB attach fails (error 9004)

[meBrian]

SQL 2000

I have a db comprised of 3 .mdf files and the .ldf
The Log was corrupted during an aborted restore. The db was detached immediately following the aborted restore through EM.
I am unable to attach the database using EM or SQL QA. I get the following err:
9004 - error occurred while processing the log file for database MyDatabase.

Unfortunately, MS offers no information.

Any ideas would be appreciated.

Thanks,
B

 

[mrdenny]

Rename the log file and attempt to attach it. When the window comes up it will show a red X next to the log file. Ignore the error. It will generate a new log file.

Once it's reattached do a full database backup.

From the command line use the sp_attach_db_single_file command.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[meBrian]

Thanks, I'll give that a try.