Posted by Erland Sommarskog on 05/16/07 22:32

Jaros³aw Kozik (jkozik@op.pl) writes:
> my database status is suspect - what can I do to rebuilt it ( using
> enterprise manager or something else ) ?

Why did it become suspect in the first place?

This is not a situation that is easy to assist with over the net, since
a lot of information may be neeeded. A database can become suspect because
of lack of disk space, because of corruption etc.

Search for "suspect" in Books Online, and see if any of the topic you
find seem to apply to your situation. Else I would recommend you to open
a case with Microsoft, at least if this a production database that would
be costly to lose.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities
• Prev in forum: Re: Database Owner cannot connect
• Thread view: Re: SQL server 2000 - database problem

[Reply to this message]