Backup will not Restore to different Instance

I dumped a database on the Prod system and tried to restore it to the Dev
system. I have done this before, but this time the Restore sits on the
'Restore Progress' window forever, with sqlserver using 1% cpu. EM shows th
e
'Restore Database' sessions with an unchanging 422 I/O. The Sql Server Log'
s
last entry is "Starting up database 'dbname'. There is no indication that
the database is actually restoring.
What the heck is happening?Have you tried to kill the spid and restart the restore?
Andrew J. Kelly SQL MVP
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:747DA3AB-46B4-476C-A54B-B07C5C33D9C0@.microsoft.com...
>I dumped a database on the Prod system and tried to restore it to the Dev
> system. I have done this before, but this time the Restore sits on the
> 'Restore Progress' window forever, with sqlserver using 1% cpu. EM shows
> the
> 'Restore Database' sessions with an unchanging 422 I/O. The Sql Server
> Log's
> last entry is "Starting up database 'dbname'. There is no indication
> that
> the database is actually restoring.
> What the heck is happening?|||Andrew,
Yes, I have. I have also cycled the Instance. When I begin the restore, the
database files are allocated but the progress window remains unchanged for a
long period of time. Alsom the instance does not appear to be using CPU or
disk. The backup was taken under 8.00.534 and the restore is under 8.00.818
.
Perhaps that is the problem?
Michael
"Andrew J. Kelly" wrote:

> Have you tried to kill the spid and restart the restore?
>
> --
> Andrew J. Kelly SQL MVP
>
> "Snake" <Snake@.discussions.microsoft.com> wrote in message
> news:747DA3AB-46B4-476C-A54B-B07C5C33D9C0@.microsoft.com...
>
>|||As a side-note, the database I am trying to restore into is created prior to
beginning the install. That database shows under EM like one would expect
until the Restore begins. Then it seems to disappear from EM (running on
another machine) and does not appear in sysdatabases.
"Snake" wrote:

> I dumped a database on the Prod system and tried to restore it to the Dev
> system. I have done this before, but this time the Restore sits on the
> 'Restore Progress' window forever, with sqlserver using 1% cpu. EM shows
the
> 'Restore Database' sessions with an unchanging 422 I/O. The Sql Server Lo
g's
> last entry is "Starting up database 'dbname'. There is no indication th
at
> the database is actually restoring.
> What the heck is happening?|||How large are the files? It can take a while to zero out large data files.
Andrew J. Kelly SQL MVP
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:1FC7C123-BDF5-432A-996F-79FABFBC8BE5@.microsoft.com...[vbcol=seagreen]
> Andrew,
> Yes, I have. I have also cycled the Instance. When I begin the restore,
> the
> database files are allocated but the progress window remains unchanged for
> a
> long period of time. Alsom the instance does not appear to be using CPU or
> disk. The backup was taken under 8.00.534 and the restore is under
> 8.00.818.
> Perhaps that is the problem?
> Michael
> "Andrew J. Kelly" wrote:
>