Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 fatal error

Author  Topic 

steel
Posting Yak Master

107 Posts

Posted - 2008-04-17 : 05:47:34
hello all
i am working on a production database on sql server 2000 with sp4 . there are java threaqds which are performing dml operations on the database. yesterday we got an error ( fatal error 667 )
and the java threads are showing the following exception sqlstate 08S01 connection terminated

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-04-17 : 06:00:32
Where are these error messages coming from? Are they from sql server og from JVM or something?

--
Lumbago
Go to Top of Page

steel
Posting Yak Master

107 Posts

Posted - 2008-04-17 : 06:05:07
quote:
Originally posted by Lumbago

Where are these error messages coming from? Are they from sql server og from JVM or something?

--
Lumbago


hi
the sqlstate error 08S01 is coming from java side and when I have applied the dbcccheckdb with repair_rebuild option the output is showing inconsistencies in indexes as well as tables.
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-04-17 : 06:17:20
Ugh, bummer

If your having problems recovering from these errors I suggest you post the entire output of DBCC CHECKDB in the DataCorruption forum. Let's hope you have those backups in order...

--
Lumbago
Go to Top of Page
   

- Advertisement -