Post reply

No database under EM ... Help

  • July 20, 2007 at 11:57 pm

    #125119

    Hi Everyone,

    In Enterprise Manager under Database I cant see any databases. It says no list ... I am very surprise since I can access all databases from Query Analyzer and can perform any activity I would like. Services are also running. If I try other objects such as Security or Management in Enterprise Manager it gives me an error "error 9001: The Log for Database Tepmdb is not available." Tempdb is enable for auto growth. There is 10GB available on the hard drive. Is anyone has face this kind of problem. Any help would be appreciated. Thanks .

    imranik@emiratesbank.com

     

  • July 22, 2007 at 11:37 am

    #721390

    have you registered any servers in EM? was it working properly before

    Everything you can imagine is real.

  • July 22, 2007 at 10:08 pm

    #721419

    Yes I have registered it and everything was working very nice for last 3 years. I know long time. Actually, I found the answer myself. The actual problem was Tempdb was corrupted. After removing tempdb log file I restarted the server and every thing was back to normal. Thanks for your help.

  • July 24, 2007 at 7:42 am

    #721908

    Check for the permissions. Check if the user has permissions to system tables in master database.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply