Groups | Blog | Home
all groups > sql server new users > october 2007 >

sql server new users : log scan number error


camarkco NO[at]SPAM hotmail.com
10/4/2007 12:20:49 AM
Hi,
I am getting the error "The log scan number (27:294:259) passed to
log scan in database 'jcl' is not valid. This error may indicate data
corruption or that the log file (.ldf) does not match the data file
(.mdf). If this error occurred during replication, re-create the
publication. Otherwise, restore from backup if the problem results in
a failure during startup. " when I try to open a connection to the
"jcl" database. Is is possible to fix this error? What could I
have done to cause this error?

Thanks,
Mark
Andrew J. Kelly
10/4/2007 9:40:24 AM
Is this a replicated db? Try running DBCC CHECKDB on that DB and see what
it says.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


[quoted text, click to view]
AddThis Social Bookmark Button