A database may become suspect for different reasons. The database may have run out of space, one of the files may be corrupt, etc.
Look up sp_add_data_file_recover_suspect_db, sp_add_log_file_recover_suspect_db or sp_resetstatus in your BOL. HTH, Tore. ----- Original Message ----- From: "Sam Thompson" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 7:10 AM Subject: (Suspect) SQL server database > Yo, > im using SQL Server 7, and viewing my list of databases, one of them is > grayed out and has (Suspect) written next to it. What does this mean? How do > I find out why it has been marked as suspect? > > Thanks > > Sam > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
