restore failed, left database in 'loading' condition

I only need one table from this restored database.  Is there any way to set
the status on the database so that I can see if the table I need is OK and
proceed from there?

I have other backups but will lose some data if I restore from them.

Thanks!
--
Mary Parkhouse

You can reset the Loading status. Try the RESTORE again with RESTART option.

--
Thanks
Ravi


"Mary" wrote:

> I only need one table from this restored database.  Is there any way to se
t
> the status on the database so that I can see if the table I need is OK and
> proceed from there?
>
> I have other backups but will lose some data if I restore from them.
>
> Thanks!
> --
> Mary Parkhouse

"Mary" <mary@discussions.microsoft.com> wrote in message
news:1CA4BB0A-6A2F-4B5C-993F- 1B299484A701@microso
ft.com...
> I only need one table from this restored database.  Is there any way to
set
> the status on the database so that I can see if the table I need is OK and
> proceed from there?
>
> I have other backups but will lose some data if I restore from them.
>
> Thanks!
> --
> Mary Parkhouse

Run the restore again.  You can give the database a different name when you
restore it.

Then you can pull the table to the "good" database using a SELECT INTO or an
INSERT/SELECT


Rick Sawtell
MCT, MCSD, MCDBA

I found the answer via google:

RESTORE DATABASE databasename WITH RECOVERY

It was evidently looking for a trn file that no longer existed.

Thanks!

Mary,

You could also use:-

RESTORE LOG <dbname> with recovery

Thanks
Hari
SQL Server MVP

"Mary" <mary@discussions.microsoft.com> wrote in message
news:C4234778-4ED7-469A-AB38- A7A6D022A252@microso
ft.com...
>I found the answer via google:
>
> RESTORE DATABASE databasename WITH RECOVERY
>
> It was evidently looking for a trn file that no longer existed.
>
> Thanks!