Enterprise Manager Hangs....

1. SQL Server 2K with Service Pack 3.x.

Steps to generate error in Enterprise Manager.

Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.

All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.

Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.

2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.

What would be the cause and remedy.

Thank you for your thoughts.

Smith

Here is the update on this issue...

Restore database window appears after long wait.... more than an hour.........

It never use to be so earlier.

What got changed recently?

SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.

When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?

Any thoughts?

Thank you,

|||

Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.

-Sue

Enterprise Manager Hangs....

1. SQL Server 2K with Service Pack 3.x.

Steps to generate error in Enterprise Manager.

Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.

All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.

Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.

2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.

What would be the cause and remedy.

Thank you for your thoughts.

Smith

Here is the update on this issue...

Restore database window appears after long wait.... more than an hour.........

It never use to be so earlier.

What got changed recently?

SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.

When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?

Any thoughts?

Thank you,

|||

|||

|||

Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.

-Sue

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:
[vbcol=seagreen]
> 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:
|||Restarting the server resolved this.
"Brent" wrote:
[vbcol=seagreen]
> 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:
|||I tried deleting the backuphistory but it didn't work. Maybe I need to
restart the server.
"Brent" wrote:
[vbcol=seagreen]
> Restarting the server resolved this.
> "Brent" wrote:
|||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:
[vbcol=seagreen]
> I tried deleting the backuphistory but it didn't work. Maybe I need to
> restart the server.
> "Brent" wrote:

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.

Enterprise Manager & User permitions

I installed Enterprise Manager on user PC and now want him to be able to
delete and restore databases. Where do I need go to do this? I'm new in SQL
server.
Thank you,
AlexMake this login a member of the dbcreator fixed server role. For example:
sp_addsrvrolemember 'loginname','dbcreator'
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Alex" <alazor@.poli-film.net> wrote in message
news:uOg8vQo5DHA.2404@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I installed Enterprise Manager on user PC and now want him to be able to
> delete and restore databases. Where do I need go to do this? I'm new in

---

SQL

quote:

---

> server.
> Thank you,
> Alex
>

---

|||I did add but it doesn't let him delete the database. It gives an error
message 3704 "User doesn't have permissions to delete database... SQL
Server-DMO ODBC SQL State 4300..."
I don't know if it has something to do with this but my SQL Server 2000 is
setup for "SQL Server and Windows Authentication" Any idea?
Thanks!
"Carlos Eduardo Rojas" <carloser@.mindspring.com> wrote in message
news:OPW6Vio5DHA.1632@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Make this login a member of the dbcreator fixed server role. For example:
> sp_addsrvrolemember 'loginname','dbcreator'
> --
> Carlos E. Rojas
> SQL Server MVP
> Co-Author SQL Server 2000 programming by Example
>
> "Alex" <alazor@.poli-film.net> wrote in message
> news:uOg8vQo5DHA.2404@.TK2MSFTNGP11.phx.gbl...
> SQL
>

---

|||Then something weird is going on. Try this script to see if it works:
sp_addlogin 'testcreatedb','testcreatedb'
go
sp_addsrvrolemember 'testcreatedb','dbcreator'
go
-- now logon using the new login and run the following
create database test
go
drop database test
go
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Alex" <alazor@.poli-film.net> wrote in message
news:u%23SYrHp5DHA.2628@.TK2MSFTNGP10.phx.gbl...

quote:

---

> I did add but it doesn't let him delete the database. It gives an error
> message 3704 "User doesn't have permissions to delete database... SQL
> Server-DMO ODBC SQL State 4300..."
> I don't know if it has something to do with this but my SQL Server 2000 is
> setup for "SQL Server and Windows Authentication" Any idea?
> Thanks!
>
> "Carlos Eduardo Rojas" <carloser@.mindspring.com> wrote in message
> news:OPW6Vio5DHA.1632@.TK2MSFTNGP12.phx.gbl...
example:[QUOTE]
to[QUOTE]
in[QUOTE]
>

---

Enterprise Manager & User permitions

I installed Enterprise Manager on user PC and now want him to be able to
delete and restore databases. Where do I need go to do this? I'm new in SQL
server.
Thank you,
AlexMake this login a member of the dbcreator fixed server role. For example:
sp_addsrvrolemember 'loginname','dbcreator'
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Alex" <alazor@.poli-film.net> wrote in message
news:uOg8vQo5DHA.2404@.TK2MSFTNGP11.phx.gbl...
> I installed Enterprise Manager on user PC and now want him to be able to
> delete and restore databases. Where do I need go to do this? I'm new in
SQL
> server.
> Thank you,
> Alex
>|||I did add but it doesn't let him delete the database. It gives an error
message 3704 "User doesn't have permissions to delete database... SQL
Server-DMO ODBC SQL State 4300..."
I don't know if it has something to do with this but my SQL Server 2000 is
setup for "SQL Server and Windows Authentication" Any idea?
Thanks!
"Carlos Eduardo Rojas" <carloser@.mindspring.com> wrote in message
news:OPW6Vio5DHA.1632@.TK2MSFTNGP12.phx.gbl...
> Make this login a member of the dbcreator fixed server role. For example:
> sp_addsrvrolemember 'loginname','dbcreator'
> --
> Carlos E. Rojas
> SQL Server MVP
> Co-Author SQL Server 2000 Programming by Example
>
> "Alex" <alazor@.poli-film.net> wrote in message
> news:uOg8vQo5DHA.2404@.TK2MSFTNGP11.phx.gbl...
> > I installed Enterprise Manager on user PC and now want him to be able to
> > delete and restore databases. Where do I need go to do this? I'm new in
> SQL
> > server.
> >
> > Thank you,
> > Alex
> >
> >
>|||Then something weird is going on. Try this script to see if it works:
sp_addlogin 'testcreatedb','testcreatedb'
go
sp_addsrvrolemember 'testcreatedb','dbcreator'
go
-- now logon using the new login and run the following
create database test
go
drop database test
go
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Alex" <alazor@.poli-film.net> wrote in message
news:u%23SYrHp5DHA.2628@.TK2MSFTNGP10.phx.gbl...
> I did add but it doesn't let him delete the database. It gives an error
> message 3704 "User doesn't have permissions to delete database... SQL
> Server-DMO ODBC SQL State 4300..."
> I don't know if it has something to do with this but my SQL Server 2000 is
> setup for "SQL Server and Windows Authentication" Any idea?
> Thanks!
>
> "Carlos Eduardo Rojas" <carloser@.mindspring.com> wrote in message
> news:OPW6Vio5DHA.1632@.TK2MSFTNGP12.phx.gbl...
> > Make this login a member of the dbcreator fixed server role. For
example:
> > sp_addsrvrolemember 'loginname','dbcreator'
> >
> > --
> > Carlos E. Rojas
> > SQL Server MVP
> > Co-Author SQL Server 2000 Programming by Example
> >
> >
> > "Alex" <alazor@.poli-film.net> wrote in message
> > news:uOg8vQo5DHA.2404@.TK2MSFTNGP11.phx.gbl...
> > > I installed Enterprise Manager on user PC and now want him to be able
to
> > > delete and restore databases. Where do I need go to do this? I'm new
in
> > SQL
> > > server.
> > >
> > > Thank you,
> > > Alex
> > >
> > >
> >
> >
>

Enterprise manager

hi,
I used backup and restore moved a database from one server to another.
Everything works fine. But I got problem view the taskpad of the database. I
could view it from another server but not this server.
right after restore I could view it but after close EM and reopen , I got
this error when trying to view the taskpad of the database:
Internet Explorer script error:
An error has occurred in the script on this page:
Line: 307
Char: 2
Error: unspecified error
Code: 0
URL:
res://c:\Program%20Files\Microsoft%20SQL%20server\80\Tools\Binn\Resources\10
33\sqlmmc.rll/Tabs.html
Could you please help!!
Thanks
Kathy ChenHi Kathy.
Hopefully someone will give you a more precise answer to the actual problem
you're experiencing, but my 20c worth on this is that you probably shouldn't
become too dependant on the MMC SnapIn TaskPads. If you search the archive
of this newsgroup you'll find a trail of destruction from others trying to
use the TaskPad views - they simply don't work very reliably. There's lots
more on this in microsoft.public.management.mmc as well.
Another thing that often fails with Task Views is in the "Table Info" tab -
this view often won't let you scroll to the next page - often the next page
nav tools are missing. It's a really nice feature, but it just doesn't work
reliably, imho. My work around to that problem was simply to use profiler to
grab what the EM was sending to the server, saved it as a script & you get
the same information.. (c:
Regards,
Greg Linwood
SQL Server MVP
"Kathy" <kathy_chen@.hotmail.com> wrote in message
news:e8SWyCEyDHA.536@.tk2msftngp13.phx.gbl...
> hi,
> I used backup and restore moved a database from one server to another.
> Everything works fine. But I got problem view the taskpad of the database.
I
> could view it from another server but not this server.
> right after restore I could view it but after close EM and reopen , I got
> this error when trying to view the taskpad of the database:
>
> Internet Explorer script error:
> An error has occurred in the script on this page:
> Line: 307
> Char: 2
> Error: unspecified error
> Code: 0
> URL:
>
res://c:\Program%20Files\Microsoft%20SQL%20server\80\Tools\Binn\Resources\10
> 33\sqlmmc.rll/Tabs.html
> Could you please help!!
> Thanks
> Kathy Chen
>
>|||Hi Kathy,
There's a very simple workaround for the scripting error you'r
encountering in Enterprise Manager.
Just right-click on the DB, click view, then click list to display th
DB objects. Go back, right-click on the DB, click view, then clic
Taskpad. It will reset the web interface and it'll work again.
Yes, another stupid bug in MSSQL SQL Server.
Best Regards,
Chuck Lee
chucksql@.hotmail.co
-
chuckle
----
Posted via http://www.mcse.m
----
View this thread: http://www.mcse.ms/message205074.htm

Enterprise Edition

Please help.
I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
and renistall a Standard version of SQL 2K. However it
does not allow restore of previous system databases. What
can I do to overcome this. please?.
Urgent
Regards
Timi.Timi,
Did you apply SP3 to your Standard Edition?
Russell Fields
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:291701c3fc9c$ff121a20$a001280a@.phx.gbl...
> Please help.
> I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
> and renistall a Standard version of SQL 2K. However it
> does not allow restore of previous system databases. What
> can I do to overcome this. please?.
> Urgent
> Regards
> Timi.|||Could you be running into this problem:
264474 PRB: System Database Backups Cannot be Restored on a Different Build
http://support.microsoft.com/?id=264474
Rand
This posting is provided "as is" with no warranties and confers no rights.

Enterprise Edition

Please help.
I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
and renistall a Standard version of SQL 2K. However it
does not allow restore of previous system databases. What
can I do to overcome this. please?.
Urgent
Regards
Timi.Timi,
Did you apply SP3 to your Standard Edition?
Russell Fields
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:291701c3fc9c$ff121a20$a001280a@.phx.gbl...
> Please help.
> I have a SQL2K EE SP 3 runing on WIN2k SP4 I uninstall
> and renistall a Standard version of SQL 2K. However it
> does not allow restore of previous system databases. What
> can I do to overcome this. please?.
> Urgent
> Regards
> Timi.|||Could you be running into this problem:
264474 PRB: System Database Backups Cannot be Restored on a Different Build
http://support.microsoft.com/?id=264474
Rand
This posting is provided "as is" with no warranties and confers no rights.