Post reply

Urgent Request - Cant see any databases in database tab in Ent Mgr

  • July 17, 2006 at 8:40 am

    #60666

    Help - Cant see any databases in Ent Mgr either from client or server. Have rebooted server few times and restarted services but to no avail. Any tips greatly appreciated.  Also no users are able to access the databases.

     

    Thanks in advance

    RAm

  • July 17, 2006 at 8:50 am

    #649574

    Can you see the registered server?

  • July 17, 2006 at 8:56 am

    #649576

    I can see the registered server and I can even see all the jobs although I can't run any.

    When I try to run a job say back up it say it is waiting for the server to start which on the services it states is started already.

  • July 17, 2006 at 11:31 am

    #649632

    Did you check the permissions of the user that runs the SQL Server? If it does not have appropriate rights then that kind of problem may occur.

  • July 17, 2006 at 11:34 am

    #649633

    Yep,

  • July 17, 2006 at 11:56 am

    #649640

    Is it possible that you accidentally restore over your existing master db? Since you are saying that you can see the "jobs" (as they are stored in msdb) and no one can login (logins are stored in master) than it looks that your master db is not the one you left.

    Check if you can see any result with that query

    select

    * from master..sysdatabases

    if you see none of your production databases than our theory should be right.

    Good luck!

  • July 18, 2006 at 7:06 am

    #649768

    Thanks to all, I left the server as it was and this morning when I came in all seem to be fine. It turns out that a colleague was doing a massive cull on a database. This cull went on for about 3 hours then the colleague decided to abandon.  So when I reatarted the server, SQL was trying to recover the database as identified in the event viewer application log. It's just that it took such a long time (4 hours).

    Thanx for all the support.

  • July 18, 2006 at 7:57 am

    #649788

    Glat to hear that you recover

    Must be a tough stress though

Viewing 8 posts - 1 through 7 (of 7 total)

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