469,627 Members | 936 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,627 developers. It's quick & easy.

SQL server 2000 - database problem

my database status is suspect - what can I do to rebuilt it ( using
enterprise manager or something else ) ?

regards IJKK
May 16 '07 #1
3 4590
Jarosław Kozik (jk****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 16 '07 #2
I think, my database is strong corupted. Becouse when I try to connect
database to server I see MSServer error 9004.

I dont konow how rebuild it .
regards IJKK
Uzytkownik "Erland Sommarskog" <es****@sommarskog.senapisal w wiadomosci
news:Xn*********************@127.0.0.1...
Jarosław Kozik (jk****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

May 17 '07 #3
Jaroslaw Kozik (jk****@op.pl) writes:
I think, my database is strong corupted. Becouse when I try to connect
database to server I see MSServer error 9004.
Error 9004: "An error occurred while processing the log for database
'%.*ls'." Seems like your log file is hosed.

If you have a recent backup of the database, restore it.

If you don't have a backup, there may be a possibility to recover the
database to some extent, but it is far from certain. Assuming that a
hardware problem thrashed the log file, it could have hit the data
file as well, if the data file is on the same disk. And there is a very
clear risk that there are one or more unrecovered and incomplete
transactions in the database. This means that once you are able to
access it, you may find corruption and/or inconsistences in your data.

If you want to know the steps to do this, please drop me a mail. I don't
want to post this on the newsgroups, because these are commands that
could cause damage if you don't know exactly what you are doing.

Also, you should examine why the log file became corrupted. This could
be a hardware issue, such a faulty disk or a bad memory board.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by Thue Tuxen Sřrensen | last post: by
17 posts views Thread by Danieltbt05 | last post: by
14 posts views Thread by Developer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.