Restore works from QA, but not EM

  • I am having a persistent problem restoring on one of my servers.  Every time I try to restore using EM, my databases get stuck in (Loading) status.  When I try it using QA, it works...about every other time, with General Network failures in between.  And all of this is only on one server.  I can restore the same .BAK files on other servers just fine.  And I've tried restoring different databases. This one server is consistently giving me problems. 

    Another note about this server, it doesn't show up in the drop down list when you go to register a server, login to QA, etc.  You can type in its name and it connects, but it's not in the list. 

    Can anyone out there give me any clues to resolving this?  I'm about ready to reinstall SQL Server completely!

    Thanks,

    J. Bagwell


    J. Bagwell

    UVA Health System

  • I've seen this error before and although it could be various things in my case it was always that SQL Server was not listening on shared memory.  The fact that your server is not showing up in the dropdown list when you register the server leads me to believe it could be the same issue.

    First of all check the error log.  right at the beginning of the log, after all the databases have been started up you should see a line that reads like this:

    SQL server listening on TCP, Shared Memory, Named Pipes.

    When you restore in QA try and perform the restore but do NOT specify the WITH STATS option.  The output of stats is performed using shared memory - in EM it uses stats by default so this is why it's always failing in EM.

    If you have established that it works when you don't use the STATS option then it's almost certainly shared memory.  All you can do is restart the SQL Services although if I'm not mistaken you might have to restart the server itself.

    Hope that helps,

Viewing 2 posts - 1 through 1 (of 1 total)

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