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!