Restore Database action not responding

I followed the "Restore Database to a new Server" process using Enterprise
Manager and T-SQL using the WITH MOVE option. Both processes seem to be
hanging.
In EM, the Restore Progress bar shows it is restoring but no progress is made.
In T-SQL, I just receive Executing Query Batch...
Any ideas on what is going on? What do I need to look at?
Thanks-
Deb
--
DebRESTORE may need to create the database before the restore actually begins
and this can take considerable time. Is this a large database?
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:30CD3ECC-B47B-44EB-A396-F3DA717F1FB2@.microsoft.com...
>I followed the "Restore Database to a new Server" process using Enterprise
> Manager and T-SQL using the WITH MOVE option. Both processes seem to be
> hanging.
> In EM, the Restore Progress bar shows it is restoring but no progress is
> made.
> In T-SQL, I just receive Executing Query Batch...
> Any ideas on what is going on? What do I need to look at?
> Thanks-
> Deb
>
> --
> Deb|||Ahhh. I will let it run overnight then. It is almost 14GB.
--
Deb
"Dan Guzman" wrote:
> RESTORE may need to create the database before the restore actually begins
> and this can take considerable time. Is this a large database?
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Deb" <Deb@.discussions.microsoft.com> wrote in message
> news:30CD3ECC-B47B-44EB-A396-F3DA717F1FB2@.microsoft.com...
> >I followed the "Restore Database to a new Server" process using Enterprise
> > Manager and T-SQL using the WITH MOVE option. Both processes seem to be
> > hanging.
> >
> > In EM, the Restore Progress bar shows it is restoring but no progress is
> > made.
> >
> > In T-SQL, I just receive Executing Query Batch...
> >
> > Any ideas on what is going on? What do I need to look at?
> >
> > Thanks-
> > Deb
> >
> >
> >
> > --
> > Deb
>
>|||I wouldn't expect this to take more than a few hours, even on modest
hardware. You can get an idea of how long it might take by checking out the
performance monitor metric: physical disk/bytes per sec.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:A980EE61-E755-4837-90CE-728E794809C5@.microsoft.com...
> Ahhh. I will let it run overnight then. It is almost 14GB.
> --
> Deb
>
> "Dan Guzman" wrote:
>> RESTORE may need to create the database before the restore actually
>> begins
>> and this can take considerable time. Is this a large database?
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Deb" <Deb@.discussions.microsoft.com> wrote in message
>> news:30CD3ECC-B47B-44EB-A396-F3DA717F1FB2@.microsoft.com...
>> >I followed the "Restore Database to a new Server" process using
>> >Enterprise
>> > Manager and T-SQL using the WITH MOVE option. Both processes seem to
>> > be
>> > hanging.
>> >
>> > In EM, the Restore Progress bar shows it is restoring but no progress
>> > is
>> > made.
>> >
>> > In T-SQL, I just receive Executing Query Batch...
>> >
>> > Any ideas on what is going on? What do I need to look at?
>> >
>> > Thanks-
>> > Deb
>> >
>> >
>> >
>> > --
>> > Deb
>>