登入
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • 問題

  • Question
    登入以投票
    0
    登入以投票
    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,
    Joe
    2009年6月3日 上午 07:09
    |

解答

所有回覆