Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Unanswered: SQL Server 2000 Error 9003

    Hi,

    I had a total server crash and lost all data except mdf and ldf files for databases.

    I need to attach these to a fresh installation but it is giving Error 9003 The LSN(XXX:XXS) passed to log scan in database "ABC" is invalid.

    I have tried using Sp_attach both for single file and N file but same error occurs.

    Is there any way to attach this to a database or atleast re-cover data ?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Sounds like a restore from backup. When was your last backup?

  3. #3
    Join Date
    Jul 2003
    Location
    Romania
    Posts
    8
    You can decalare a new database with the same name as your lost database was. The mdf and ldf name of this new db must be as same as your mdf and ldf is.
    Now the database it is registered in the database system.
    Then you can replace the new created files mdf and ldf with the ones you have saved.

    Hope that help.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Exactly how does this synchronize the new log file LSN with the old data file LSN? Or fix the damaged LSN in the old log file?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •