Hello,

I get the following error when each night when I backup.
The dayabase has become suspect about 5 times.

I have to restore a backup to continue. Luckily I am running SQL 2005 standard edition and run a seperate SQL Agent backup.

I have logged the support call with Kaseya(nearly 1 month ago), I keep getting told that the developers will look into it.

I have also dropped and recreated all the indexes as when I ran CHECK DBCC it suggested some of the indexes had problems.

But I still get the error below and it is driving me nuts.

Any ideas?



Database backup failed at 6:50:03 pm 16-Feb-07 System database backup failed.

Check Data and Index Linkage - [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1977826158, index ID 1, partition ID 411093791801344, alloc unit ID 411093791801344 (type In-row data). Parent node for page (1:77388) was not encountered.

[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1977826158, index ID 1, partition ID 411093791801344, alloc unit ID 411093791801344 (type In-row data). The previous link (1:77388) on page (1:77389) does not match the previous page (1:77644) that the parent (1:9395



Mike


Legacy Forum Name: Database backup failed,
Legacy Posted By Username: mfelder