MS KB lists article ID Q274266 for the boolean search query '3624 and "SQL Server"'. I'm not sure whether you are getting the error during recovery of such a statement. If your are running SQL Server 7 SP2, you may consider installing SP3 and then trying again.
HTH, Tore. ----- Original Message ----- From: "Sam Thompson" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 12:07 PM Subject: Re: (Suspect) SQL server database > 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.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
