Enterprise Manager hangs

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.Hi
Perhaps you need to delete a backup history
http://weblogs.sqlteam.com/geoffh/archive/2008/01/21/MSDB-Performance-Tuning.aspx
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:B67B18F5-2ACD-49E5-A7EA-AA5A65487B68@.microsoft.com...
> 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.|||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.
"ronnie" wrote:
> 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.|||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?
"Brent" wrote:
> 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.
> "ronnie" wrote:
> > 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.|||Restarting the server resolved this.
"Brent" wrote:
> 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?
> "Brent" wrote:
> > 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.
> >
> > "ronnie" wrote:
> >
> > > 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.|||I tried deleting the backuphistory but it didn't work. Maybe I need to
restart the server.
"Brent" wrote:
> Restarting the server resolved this.
> "Brent" wrote:
> > 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?
> >
> > "Brent" wrote:
> >
> > > 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.
> > >
> > > "ronnie" wrote:
> > >
> > > > 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.|||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.
"ronnie" wrote:
> I tried deleting the backuphistory but it didn't work. Maybe I need to
> restart the server.
> "Brent" wrote:
> > Restarting the server resolved this.
> >
> > "Brent" wrote:
> >
> > > 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?
> > >
> > > "Brent" wrote:
> > >
> > > > 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.
> > > >
> > > > "ronnie" wrote:
> > > >
> > > > > 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.