Problem attaching a database.

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello Eric,

Here is my problem. Any solution.

Got the foll. error message when trying to attach a database in sql 7.0, using sp_attach_db. The path and filenames are correct.

sp_attach_db 'DBsource','c:\mssql7\data\DBsource.mdf', 'c:\mssql7\data\DBsource.ldf'

Error Message: Changed language setting to us_english. Server: Msg 9003, Level 20, State 1, Line 1 The LSN (552:290:1) passed to log scan in database 'DBsource' is invalid.

Connection Broken

Thanks, Ranga

-- Anonymous, October 08, 1999

Answers

Ranga,

You seem to be way out front here. I could not find any good advice from the usual sources. It seems that the log reader has problems. See if you can devise a way to first truncate the log or remove it or not attach it. Failing that, contact Microsoft PSS (Priority Support Services). Chances are fairly good that it is a MS bug, in which case MS does not charge for the support incident, or at least a misleading error message (which often counts as a bug as well).

Good Luck,

Eric

-- Anonymous, October 11, 1999


Moderation questions? read the FAQ