Enterprise Manager hangs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ronnie - 19 Mar 2008 14:24 GMT

Hi,

I have a production server which has about six user databases. Recently,
when I try to do a restore ( I wanted to see the available backup sets) on
any of the databases using Enterprise Manager (All Tasks -> Restore) it
hangs. However, it promptly brings a pop up window when I do the All Tasks ->
Backup. What might be causing it to behave this way?

Thanks in advance.

Reply to this Message

Uri Dimant - 19 Mar 2008 14:46 GMT

Hi
Perhaps you need to delete a backup history
http://weblogs.sqlteam.com/geoffh/archive/2008/01/21/MSDB-Performance-Tuning.aspx

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks in advance.

Reply to this Message

Brent - 19 Mar 2008 16:58 GMT

We are seeing this too. The only change we have done recently is applying
SLQ Server Cum 6 for SP2. Management Studio hangs when we attempt to restore
from a device. Specifically, it hangs when we click "Add" on the Specify
Backup dialog. We have no problems using the "From Database" option, so I do
not believe it has anything to do with MSDB indexes.

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks in advance.

Reply to this Message

Brent - 19 Mar 2008 17:50 GMT

I have narrowed this down to the command "insert #avmed exec
master.dbo.xp_availablemedia", which is what is hanging. I ran "exec
master.dbo.xp_availablemedia" stand alone, and it hangs. This is calling DLL
xpStar90.dll. Has anyone ever seen what might cause this?

> We are seeing this too. The only change we have done recently is applying
> SLQ Server Cum 6 for SP2. Management Studio hangs when we attempt to restore
[quoted text clipped - 11 lines]
> >
> > Thanks in advance.

Reply to this Message

Brent - 19 Mar 2008 20:30 GMT

Restarting the server resolved this.

> I have narrowed this down to the command "insert #avmed exec
> master.dbo.xp_availablemedia", which is what is hanging. I ran "exec
[quoted text clipped - 16 lines]
> > >
> > > Thanks in advance.

Reply to this Message

ronnie - 20 Mar 2008 19:43 GMT

I tried deleting the backuphistory but it didn't work. Maybe I need to
restart the server.

> Restarting the server resolved this.
>
[quoted text clipped - 18 lines]
> > > >
> > > > Thanks in advance.

Reply to this Message

Brent - 21 Mar 2008 16:50 GMT

Our SQL Instance is clustered, so we failed over to the other node and
everything is fine. As soon as we restarted the node where things were
hanging, we started getting alerts on that the C drive is going bad. I think
this is why it was having trouble calling the dll. You may have a similar
issue. Are you using any monitoring tools like Sitescope to monitor the
hardware? You may have a drive that is going bad.

> I tried deleting the backuphistory but it didn't work. Maybe I need to
> restart the server.
[quoted text clipped - 21 lines]
> > > > >
> > > > > Thanks in advance.

Reply to this Message