Error 644 for msdb - SQL Server Forums

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

MSDE (2000)

Error 644 for msdb

Author

Topic

vandals81
Starting Member

6 Posts

Posted - 2007-07-26 : 14:03:37

I have created a backup job on MSDE, but I now need to delete this job. I am using SQL Server Enterprise Manager to manage the database, so when I right click on the job and hit delete I get this error message:
Error 644: Could not find the index entry for RID '163bd10000010000' in index page (1:553), index ID 0, database 'msdb'

What is wrong?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-26 : 14:12:45

Run DBCC CHECKDB against the msdb database. Does that command show errors?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

vandals81
Starting Member

6 Posts

Posted - 2007-07-26 : 14:34:21

Yes it does
DBCC results for 'sysdtssteplog'.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:343) on page (1:371) does not match the previous page (1:382) that the parent (1:300), slot 32 expects for this page.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. Page (1:371) is missing a reference from previous page (1:343). Possible chain linkage problem.
There are 0 rows in 0 pages for object 'sysdtssteplog'.

and

DBCC results for 'sysjobhistory'.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:382) on page (1:564) does not match the previous page (1:371) that the parent (1:300), slot 33 expects for this page.
There are 626 rows in 208 pages for object 'sysjobhistory'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysjobhistory' (object ID 2073058421).

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-26 : 14:42:37

Your msdb is corrupted. You'll want to start a new thread in the Data Corruption forum here so that Microsoft Engineers can assist you with this.

Here is that forum:
http://www.sqlteam.com/forums/forum.asp?FORUM_ID=22

Start a new thread and mention that DBCC CHECKDB is failing on the msdb database. Then post the entire output of the command without any modifications.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

vandals81
Starting Member

6 Posts

Posted - 2007-07-26 : 15:44:16

Thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources