Can a database become suspect after being opened in STANDBY mode?

Hello,
I have an MS SQL Server 2000 SP3 database. My question is whether I can be
confident it won't become suspect after it has been successfully opened in
STANDBY mode. Can I use the fact as an indicator that the database won't go
suspect when I later try to open it RECOVERY mode?
-- Many thanks, OskarOn Oct 4, 5:20 pm, Oskar <Os...@.discussions.microsoft.com> wrote:
> Hello,
> I have an MS SQL Server 2000 SP3 database. My question is whether I can be
> confident it won't become suspect after it has been successfully opened in
> STANDBY mode. Can I use the fact as an indicator that the database won't go
> suspect when I later try to open it RECOVERY mode?
> -- Many thanks, Oskar
Didn't test it, but I do think that the database can become suspect
even if it is in standby mode. If you have a hardware failure, it can
cause the database to get into suspect status. For example if
something gets wrong with your storage, and the disk suddenly
disappears, then the database can get into suspect status. Of course
it is rare that something like that happens.
Adi|||At that stage hardware faults would already be fixed.
"Adi" wrote:
> On Oct 4, 5:20 pm, Oskar <Os...@.discussions.microsoft.com> wrote:
> > Hello,
> > I have an MS SQL Server 2000 SP3 database. My question is whether I can be
> > confident it won't become suspect after it has been successfully opened in
> > STANDBY mode. Can I use the fact as an indicator that the database won't go
> > suspect when I later try to open it RECOVERY mode?
> >
> > -- Many thanks, Oskar
> Didn't test it, but I do think that the database can become suspect
> even if it is in standby mode. If you have a hardware failure, it can
> cause the database to get into suspect status. For example if
> something gets wrong with your storage, and the disk suddenly
> disappears, then the database can get into suspect status. Of course
> it is rare that something like that happens.
> Adi
>