Attaching database fail , Error 9003 The LSN passed to log scan in database is invalid.
Posted on 2009-04-01
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?