EM locking on 7.0 restore database

When I try to retore a database on my 7.0 server, EM locks
up and quits responding.
On my workstation, I have EM2000, which I know is a
problem (thanks to KB # 312537) but the same thing happens
when I try it using he version of EM that is on that
server.
(I guess I'm assuming that EM is 7.0, is there a way to
check?)
Any other ideas? Thanks MarkHi Mark.
If you see the SQL Enterprise Manager hanging, don't assume that the server
(often another physical computer) is not actually performing any work.When
I'm restoring a db & wondering how it's going, I generally just monitor
something simple, such as CPU usage for the SPID that's controlling the
restore task to ensure that the server is actually performing work.
If you're technically minded / interested, the SQL Enterprise Manager is a
Microsoft Management Console (MMC) SnapIn type application. MMC SnapIns run
within the MMC Console process, which itself provides only a single thread
for managing all of it's SnapIns. If a dialog in a SnapIn such as the backup
restore is designed to "hang", waiting for a response from a server
application (such as SQL Server), the problem is that it doesn't allow the
user to continue interacting with other aspects of the SnapIn. Even worse,
the MMC Console might have other management SnapIns loaded (right click on
"My Computer" & select "Manage", then expand "Services and Applications" for
an example of a console where many SnapIns are loaded into a single
Console). If one hangs the MMC Console thread (such as the SQL Restore
dialog), all SnapIns are hung along with it! This can be bad if the other
SnapIns are doing something important.
That was a bit of a rant, but basically, this is why I avoid using the SQL
7.0 EM restore dialog like the plague - it hangs the GUI SnapIn Console. If
you simply use the RESTORE command from Query Analyser, you get
informational progress messages which at least let you know how things are
going.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Mark Hoyt" <mhoyt@.affiliatedhealth.org> wrote in message
news:061701c38d1a$e5f942d0$a301280a@.phx.gbl...
> When I try to retore a database on my 7.0 server, EM locks
> up and quits responding.
> On my workstation, I have EM2000, which I know is a
> problem (thanks to KB # 312537) but the same thing happens
> when I try it using he version of EM that is on that
> server.
> (I guess I'm assuming that EM is 7.0, is there a way to
> check?)
> Any other ideas? Thanks Mark|||Thanks Greg,
This turned out to be exactly the problem, I was just too
quick to assume "not responding" meant I had a problem.
Starting the process, going out to breakfast, and coming
back was all it took.
Thanks for the help!
>--Original Message--
>Hi Mark.
>If you see the SQL Enterprise Manager hanging, don't
assume that the server
>(often another physical computer) is not actually
performing any work.