sql server 2000 error 9003 (fail to attach a database) RRS feed

  • 問題

  • Dear all,

    After i restarted my server, one of the database is in suspended mode.  i then detached it and tried to attached it again but it shows an error message below:

    error 9003: The LSN (109813:139185:2) PASSED TO LOG SCAN IN DATABASE 'Local1' IS INVALID

    I think the reason may be that the log file is too large, but I am not sure how to shrink the file as I cannot see the database from the enterprise manager.  Please help, thanks a lot!

    Best regards,
    2009年6月3日 上午 07:09