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
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