Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9146
  • Last Modified:

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?
0
Thirt
Asked:
Thirt
  • 2
1 Solution
 
ThirtAuthor Commented:
MS SQL Server 2000
0
 
reb73Commented:
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:
Tried to attach without the log file and same problem. I guess we just need to restore last good back up.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now