Attaching database fail , Error 9003 The LSN passed to log scan in database is invalid.

Client just had a lock up on Friday and unable to start MSSQL service due to what appeared is a copurpt Master database. When through the steps to recover and restore the master database. SQL service now loading and able to view database in EM. Howerver, 2 of the 3 were showing the status as "suspect". So I de-tached one of them and went to re-attach and get the following error:

"Error 9003: The LSN(##:##:##) passed to log scan in database 'databasename' is invalid."

So I suspect what ever happened on friday also caused a problem with the databases in question. I think we can restore those from back up. But do I have anything else I can try for now?
LVL 4
ThirtAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
reb73Connect With a Mentor Commented:
Your log files may be corrupted as well, causing the database to be marked suspect when recovering logs..

Try attaching only the mdf files to see if it works for you.. Also have a look at the link below -

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78376
0
 
ThirtAuthor Commented:
MS SQL Server 2000
0
 
ThirtAuthor Commented:
Tried to attach without the log file and same problem. I guess we just need to restore last good back up.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.