| Author |
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 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
| |
| Rick Sawtell 2005-06-29, 11:23 am |
|
"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!
| |
| Hari Prasad 2005-06-29, 8:23 pm |
| 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!
|
|
|
|