Error while attaching database

[guptakaps]

I get this error while attaching database to the SQL Server:

"Error 9003: The LSN (11772:1180:1) passed to log scan in database '<dbname>' is invalid."

If it helps in any way. the title of the message box window displays this text:
"Microsoft SQL-DMO (ODBC SQLState: HY000)

Can any help please?

Thanks
K.

 

[nickspace]

here's what microsoft has to say about that:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328354

Hope this helps

 

[guptakaps]

well, this article assumes the database is already attached to the SQL Server

And, we are already running SP3

K.

 

[mrdenny]

I would try to attach without the log file by using the sp_attach_single_file_db procedure.

Denny
MCSA (2003) / MCDBA (SQL 2000)

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

http://www.mrdenny.com