Thanks Tore. Ive now deleted the suspect database and kept the MDF and LDF files. Ive created a new database and im trying to use sp_attach_db to attach the files, but I keep getting this error:
Server: Msg 3624, Level 20, State 1, Line 1 Location: recovery.c:2693 Expression: seenCkptEnd SPID: 12 Process ID: 133 Connection Broken Any Ideas??!?!?!?!!? Thanks Sam ----- Original Message ----- From: "Tore Bostrup" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 5:00 PM Subject: Re: (Suspect) SQL server database > 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.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
