Production DBs are going to suspect mode automatically

Dear All,
In our server,Our Production DBs are going to suspect mode automatically.
Any body help us for this issues.
Regards,
R.SathiamoorthyHi
http://www.karaszi.com/sqlserver/in..._suspect_db.asp
"Sathiamoorthy" <someone@.microsoft.com> wrote in message
news:%23kcjEUmgHHA.392@.TK2MSFTNGP06.phx.gbl...
> Dear All,
> In our server,Our Production DBs are going to suspect mode automatically.
> Any body help us for this issues.
> Regards,
> R.Sathiamoorthy
>
>
>|||Hello,
Can you check:-
1. Do u have enough hard disk space in data and log drices?
2. Does this happen after the SQL Server service restart, in this case the
MDF or LDF will be used by anti virus software or some backup jobs. Due
to this file willl not be available for recovery and will be marked suspect.
Verify both the above steps.
THnaks
Hari
"Sathiamoorthy" <someone@.microsoft.com> wrote in message
news:%23kcjEUmgHHA.392@.TK2MSFTNGP06.phx.gbl...
> Dear All,
> In our server,Our Production DBs are going to suspect mode automatically.
> Any body help us for this issues.
> Regards,
> R.Sathiamoorthy
>
>
>|||The first think you should do is look at the SQL Server error log. The log
should be an indication of why SQL Server marked the database suspect.
Hope this helps.
Dan Guzman
SQL Server MVP
"Sathiamoorthy" <someone@.microsoft.com> wrote in message
news:%23kcjEUmgHHA.392@.TK2MSFTNGP06.phx.gbl...
> Dear All,
> In our server,Our Production DBs are going to suspect mode automatically.
> Any body help us for this issues.
> Regards,
> R.Sathiamoorthy
>
>
>