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 |
|
SQLDiva
Starting Member
26 Posts |
 Posted - 2005-07-17 : 11:22:02
|
| My msdb backup failed, and I did a check db - got the following errors:There are 320 rows in 4 pages for object 'RTblRelColDefs'.Server: Msg 8928, Level 16, State 2, Line 1Object ID 2069582411, index ID 0: Page (1:13864) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 2069582411, index ID 0, page (1:13864). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 2069582411, index ID 0: Page (1:14784) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 2069582411, index ID 0, page (1:14784). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.There are two other tables within msdb throwing similar errors. I want to rule out data corruption before I give it to the hardware person (because otherwise, my development environment is down tomorrow for the hardware guy to troubleshoot). I have hard backups of all my dts packages on that server, and can easily rebuild the jobs from other servers. So, my question is this, is there a way (without a good backup) to rebuild a msdb in sql server 2000? I have found Microsoft articles on rebuilding in 6.5 and 7.0, but nothing for 2000. ideas?Thanks,Ann |
|
|
|
|
|
|
|
Rebuilding msdb?