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 - 2001-04-25 : 08:56:08
|
Bob writes "SQL 7.0 sp 2
NT 4
We have several replication jobs which run at different intervals. All are push and most run without problems. We have a set of three jobs that replicate different database info to a single db on a test server. the data is used for training. About a month ago we began getting the following error when either of the three jobs ran:
___________________
DATE/TIME: 4/22/01 10:30:02 PM
DESCRIPTION: Error: 644, Severity: 21, State: 1
Could not find the index entry for RID '168a54350100' in index page (1:994), index ID 0, database 'msdb'.
COMMENT: (None)
JOB RUN: (None)
________________________
We were unable to rightclick in Enterprise Mgr and obtain any details; EM would freeze and the server would require reboot to recover. Subsequently I have been able to stop the errors on two of the jobs by selecting "Refresh job" immediately after a restart of SQL. The third job however continues to send the error whenever the job runs. The "DATE/TIME" & "RID # " changes but the other data in the Error remains constant. I suspect msdb is corrupt but cannot currently afford the downtime and effort to rebuild the jobs required if I rebuild msdb. Any assistance appreciated." |
|
|
|
|
|
Error upon run of replication job