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)
 object ID 2, index ID 255

Author  Topic 

skalm
Starting Member

1 Post

Posted - 2006-02-23 : 13:11:46
Can anyone explain what this means? I get this each time the maintenance plan I have set up to back up the transaction logs for a database.
Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8968: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: IAM page (1:958) (object ID 2, index ID 255) is out of the range of this database.

How do I fix this? Thanks for any help!

Steve Kalm
DBA - RxAmerica

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-23 : 13:13:29
Looks like you've got some corruption. What does DBCC CHECKDB return? If it returns any errors, you'll want to post the entire output in the Data Corruption forum here as MS engineers who wrote DBCC frequent that forum to assist us with data corruption issues.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -