database restore from backup file.

Hello everyone,
Is it normal for a restore to take over an hour? It was backed up to a
file and that took around 3 minutes. But the restore is up to 65 minutes
now. All hard disk activity seems to have been stopped for about 50 to 55
minutes now and the database (in enterprise manager) still shows up grayed
out with a name of [DB NAME](Loading). The database itself is a little over
800 megs in size, but again there is no HD activity that I can see on it.
Anyone have an idea?
Regards,
-TonyDid you do refresh in EM? Or just to be certain, exit EM and start again.
Also, did you do the restore with the RECOVERY not the NORECOVERY option?
You could always try below from Query Analyzer:
RESTORE DATABASE dbname WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Tony Kirk" <tkirk@.metlabs.com> wrote in message
news:eoFX%23fv%23DHA.3536@.TK2MSFTNGP10.phx.gbl...
> Hello everyone,
> Is it normal for a restore to take over an hour? It was backed up to a
> file and that took around 3 minutes. But the restore is up to 65 minutes
> now. All hard disk activity seems to have been stopped for about 50 to 55
> minutes now and the database (in enterprise manager) still shows up grayed
> out with a name of [DB NAME](Loading). The database itself is a little
over
> 800 megs in size, but again there is no HD activity that I can see on it.
> Anyone have an idea?
> Regards,
> -Tony
>|||Refreshing and restarting EM did nothing to change the status of teh
database. However now the (Loading) has stopped but the database has now
disappeared on me. I've never known that to be normal. can't think of where
else to look for it now. The file is in the correct place, it's just the
database isn't showing up. Any ideas on that one? :)
Regards,
-Tony
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ekQVZzv%23DHA.1452@.TK2MSFTNGP09.phx.gbl...
> Did you do refresh in EM? Or just to be certain, exit EM and start again.
> Also, did you do the restore with the RECOVERY not the NORECOVERY option?
> You could always try below from Query Analyzer:
> RESTORE DATABASE dbname WITH RECOVERY
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Tony Kirk" <tkirk@.metlabs.com> wrote in message
> news:eoFX%23fv%23DHA.3536@.TK2MSFTNGP10.phx.gbl...
> > Hello everyone,
> > Is it normal for a restore to take over an hour? It was backed up to a
> > file and that took around 3 minutes. But the restore is up to 65 minutes
> > now. All hard disk activity seems to have been stopped for about 50 to
55
> > minutes now and the database (in enterprise manager) still shows up
grayed
> > out with a name of [DB NAME](Loading). The database itself is a little
> over
> > 800 megs in size, but again there is no HD activity that I can see on
it.
> >
> > Anyone have an idea?
> >
> > Regards,
> > -Tony
> >
> >
>|||Have a look in master..sysdatabases to see if it shows up and what the
status bitmask is.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tony Kirk" <tkirk@.metlabs.com> wrote in message
news:ucvyjDw%23DHA.220@.TK2MSFTNGP09.phx.gbl...
> Refreshing and restarting EM did nothing to change the status of teh
> database. However now the (Loading) has stopped but the database has now
> disappeared on me. I've never known that to be normal. can't think of
where
> else to look for it now. The file is in the correct place, it's just the
> database isn't showing up. Any ideas on that one? :)
> Regards,
> -Tony
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ekQVZzv%23DHA.1452@.TK2MSFTNGP09.phx.gbl...
> > Did you do refresh in EM? Or just to be certain, exit EM and start
again.
> >
> > Also, did you do the restore with the RECOVERY not the NORECOVERY
option?
> > You could always try below from Query Analyzer:
> >
> > RESTORE DATABASE dbname WITH RECOVERY
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "Tony Kirk" <tkirk@.metlabs.com> wrote in message
> > news:eoFX%23fv%23DHA.3536@.TK2MSFTNGP10.phx.gbl...
> > > Hello everyone,
> > > Is it normal for a restore to take over an hour? It was backed up to
a
> > > file and that took around 3 minutes. But the restore is up to 65
minutes
> > > now. All hard disk activity seems to have been stopped for about 50
to
> 55
> > > minutes now and the database (in enterprise manager) still shows up
> grayed
> > > out with a name of [DB NAME](Loading). The database itself is a little
> > over
> > > 800 megs in size, but again there is no HD activity that I can see on
> it.
> > >
> > > Anyone have an idea?
> > >
> > > Regards,
> > > -Tony
> > >
> > >
> >
> >
>|||Seems like the restore didn't take place for any reason. I'd try the restore
again. If that doesn't work, do it from Query analyzer so there is no doubt
on what happens, error messages etc.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Tony Kirk" <tkirk@.metlabs.com> wrote in message
news:ucvyjDw%23DHA.220@.TK2MSFTNGP09.phx.gbl...
> Refreshing and restarting EM did nothing to change the status of teh
> database. However now the (Loading) has stopped but the database has now
> disappeared on me. I've never known that to be normal. can't think of
where
> else to look for it now. The file is in the correct place, it's just the
> database isn't showing up. Any ideas on that one? :)
> Regards,
> -Tony
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ekQVZzv%23DHA.1452@.TK2MSFTNGP09.phx.gbl...
> > Did you do refresh in EM? Or just to be certain, exit EM and start
again.
> >
> > Also, did you do the restore with the RECOVERY not the NORECOVERY
option?
> > You could always try below from Query Analyzer:
> >
> > RESTORE DATABASE dbname WITH RECOVERY
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "Tony Kirk" <tkirk@.metlabs.com> wrote in message
> > news:eoFX%23fv%23DHA.3536@.TK2MSFTNGP10.phx.gbl...
> > > Hello everyone,
> > > Is it normal for a restore to take over an hour? It was backed up to
a
> > > file and that took around 3 minutes. But the restore is up to 65
minutes
> > > now. All hard disk activity seems to have been stopped for about 50
to
> 55
> > > minutes now and the database (in enterprise manager) still shows up
> grayed
> > > out with a name of [DB NAME](Loading). The database itself is a little
> > over
> > > 800 megs in size, but again there is no HD activity that I can see on
> it.
> > >
> > > Anyone have an idea?
> > >
> > > Regards,
> > > -Tony
> > >
> > >
> >
> >
>|||Well currently I'm trying another restore and it's bitmask is 32. If it
happens again I'll check in there to see if the status is before doing
anything else. Thanks.
Regards,
-Tony Kirk
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:OVkEMZw%23DHA.1796@.TK2MSFTNGP12.phx.gbl...
> Have a look in master..sysdatabases to see if it shows up and what the
> status bitmask is.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Tony Kirk" <tkirk@.metlabs.com> wrote in message
> news:ucvyjDw%23DHA.220@.TK2MSFTNGP09.phx.gbl...
> > Refreshing and restarting EM did nothing to change the status of teh
> > database. However now the (Loading) has stopped but the database has now
> > disappeared on me. I've never known that to be normal. can't think of
> where
> > else to look for it now. The file is in the correct place, it's just the
> > database isn't showing up. Any ideas on that one? :)
> >
> > Regards,
> > -Tony
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > message news:ekQVZzv%23DHA.1452@.TK2MSFTNGP09.phx.gbl...
> > > Did you do refresh in EM? Or just to be certain, exit EM and start
> again.
> > >
> > > Also, did you do the restore with the RECOVERY not the NORECOVERY
> option?
> > > You could always try below from Query Analyzer:
> > >
> > > RESTORE DATABASE dbname WITH RECOVERY
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at:
> > >
> >
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> > >
> > >
> > > "Tony Kirk" <tkirk@.metlabs.com> wrote in message
> > > news:eoFX%23fv%23DHA.3536@.TK2MSFTNGP10.phx.gbl...
> > > > Hello everyone,
> > > > Is it normal for a restore to take over an hour? It was backed up
to
> a
> > > > file and that took around 3 minutes. But the restore is up to 65
> minutes
> > > > now. All hard disk activity seems to have been stopped for about 50
> to
> > 55
> > > > minutes now and the database (in enterprise manager) still shows up
> > grayed
> > > > out with a name of [DB NAME](Loading). The database itself is a
little
> > > over
> > > > 800 megs in size, but again there is no HD activity that I can see
on
> > it.
> > > >
> > > > Anyone have an idea?
> > > >
> > > > Regards,
> > > > -Tony
> > > >
> > > >
> > >
> > >
> >
> >
>