473,320 Members | 2,161 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 4704
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
19
by: Thue Tuxen Sørensen | last post by:
Hi everybody ! I´m maintaining a large intranet (approx 10000 concurrent users) running on one IIS box and one DB box with sqlserver 2000. Currently there is 2,5 GB Ram, 1 1400 mhz cpu and 2...
5
by: Lorax | last post by:
I'm on the IS team of a medium-sized non-profit with international reach. We're trying to make some decisions regarding our Web server and database server as we expand our web site to have more...
0
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed :...
4
by: Bon | last post by:
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to...
17
by: Danieltbt05 | last post by:
just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
14
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can...
2
by: sqlgirl | last post by:
Hi, We have 2 servers. Server1 is a 2000 box, with SP3 (yes I know it is not up to date). Server2 is a 2005 box, SP2. I set up Server1 (2000) to have a linked server to Server2 (2005). The...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.