[dba-SQLServer]Database is Suspect

Thanks Stephen.
I contacted Microsoft support, and after a lot of tuning, CheckDB ended
up repairing the errors.
Thanks for the suggestion.

Mark

-----Original Message-----
From: Stephen Hait [mailto:shait at mindspring.com] 
Sent: Monday, September 08, 2003 5:35 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer]Database is Suspect

You might check the repair options of DBCC CHECKDB.

Regards,
Stephen

> I tried connecting to a SQL2K database, but received the following
> error: "Error 926 - Database cannot be opened.  It has been marked
> SUSPECT by recovery".
> 
> This database is approximately 385GB, so we have no backup to
> restore.
> 
> Any ideas?
> 
> 
> 
> Mark Boyd
> 
> Sr. Systems Analyst
> 
> McBee Associates, Inc.
> 
> 
> 
> 


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com