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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-23 : 09:06:16
|
| RyanV writes "HelloWe are currently running SQL Server 6.5 (Service Pack 4) on Windows NT Server (Service pack 6a) We have scheduled tasks set up to run different tasks at different days and times. For 1 of our task, it keeps on FAILINGFor our database: company1We run this task: dbcc newalloc with no_infomsgsTHIS TASK KEEPS ON FAILING!!When I check the Error Log, it says this:Extent 154136 is in the wrong segmentChain processed with bad segment for object 5Extent 165448 is in the wrong segmentChain processed with bad segment for object 89767377Extent 180744 is in the wrong segment.........What could have caused this ??How can we fix this problem ??Thanks " |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-24 : 00:01:00
|
| Your data is corrupted.If you have a good backup, restore.And for god's sake upgrade!At least to SP5a but you really should go to 7.0 at a minnimum.-Chad |
 |
|
|
|
|
|
Scheduled Task: dbcc Newalloc (Keeps on Failing)!!