Here are some possible solutions

Resetting the Suspect Status
Microsoft® SQL Server™ 2000 returns error 1105 and sets the status column of
sysdatabases to suspect if SQL Server is unable to complete recovery on a
database because the disk drive no longer has any free space. Follow these
steps to resolve the problem:

Execute sp_resetstatus.


Use ALTER DATABASE to add a data file or log file to the database.


Stop and restart SQL Server.
With the extra space provided by the new data file or log file, SQL Server
should be able to complete recovery of the database.

Free disk space and rerun recovery.




Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com






>From: "suresh kumar "
><mssqldba-ezmlmshield-x27857944.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: Re: Databse In Suspect Mode
>Date: Tue, 29 Jun 2004 06:16:16 -0700 (PDT)
>Received: from www.websitesondatabases.com ([216.234.186.193]) by
>mc5-f14.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Tue, 29 Jun 2004
>06:30:18 -0700
>Received: (qmail 10571 invoked by uid 121); 29 Jun 2004 13:59:05 -0000
>Received: (qmail 28355 invoked from network); 29 Jun 2004 13:59:5 -0000
>X-Message-Info: JGTYoYF78jGtFQKJWXzgM9q92zIngcuG
>Mailing-List: contact mssqldba-[Email address protected] run by ezmlm
>Precedence: bulk
>X-No-Archive: yes
>List-Post: <mailto:[Email address protected]
>List-Help: <mailto:mssqldba-[Email address protected]
>List-Unsubscribe: <mailto:mssqldba-[Email address protected]
>List-Subscribe: <mailto:mssqldba-[Email address protected]
>Delivered-To: mailing list [Email address protected]
>Message-ID: <20040629135905.10566.[Email address protected]
>Return-Path: mssqldba-return-6804-MCP111=hotmail.[Email address protected]
>X-OriginalArrivalTime: 29 Jun 2004 13:30:19.0193 (UTC)
>FILETIME=[38991A90:01C45DDD]
>
>Hi,
>
>Try to restore from the oldbackup.
> If u Dont have oldbackup use sp_resetstatus<dbname>
>
>Regards
>Suresh Kumar
>
>Madhusudan Ranganath Dumbre <mssqldba-ezmlmshield-x50043070.[Email address
>protected] wrote:
>Dear All,
>
>Can anyone help me to solve my problem.
>
>My one Database shows suspected.
>
>I already tried to recover DBCC DB Recover But not successfull
>
>pls help me out
>
>Regards
>
>Madhusudan
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
>---------------------------------
>Do you Yahoo!?
>Read only the mail you want - Yahoo! Mail SpamGuard.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>



MS Sql Server LazyDBA home page