Friday, March 9, 2012

Restore a Suspect Database

Is there a quick way of restoring a suspect database without recycling the
services ?. I did set the status to -32768 and moving the database into
another database..........Any other (Easier way) ?
Thanks.DXC
Last good backup of this database
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:9C67B96A-312B-41E7-9F38-48A12D8BD7D9@.microsoft.com...
> Is there a quick way of restoring a suspect database without recycling the
> services ?. I did set the status to -32768 and moving the database into
> another database..........Any other (Easier way) ?
>
> Thanks.
>|||You need a good backup
or
If its not available.
Try to export tables data using DTS.
May be you are successful to import the tables if that one is not
corrupted.
Regards|||That is OK..........For some reason when I delete (Dropped) the database,
it did not delete the *.mdf and *.ldf files. Then I was able to attached the
database......
"DXC" wrote:

> Is there a quick way of restoring a suspect database without recycling the
> services ?. I did set the status to -32768 and moving the database into
> another database..........Any other (Easier way) ?
>
> Thanks.
>

No comments:

Post a Comment