Posted by Taqyon on 12/05/75 11:30

Hi Guys

I'm recovering from a hard disk crash, trying to reattach recovered
files.

The MDF file seems fine, but I get:

"Server: Msg 9004, Level 23, State 1, Line 1
An error occurred while processing the log for database
'NetCoverAdmin'."

when I try to include the LDF file. My command was:

EXEC sp_attach_db @dbname = N'NetCoverAdmin',
@filename1 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\NetcoverAdmin_Data.MDF',
@filename2 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\NetcoverAdmin_Log.LDF'

Is there any way I can restore the database without the LDF file?

My backups where on another disk that mysteriously failed at the same
time, so I have to work what I got...

Any help appreciated!!

Thanks

• Next in forum: Re: String manipulation challenge in SQL
• Prev in forum: Statement for returning stored procedure params
• Thread view: Attaching MDF without LDF

[Reply to this message]