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 |
|
shree_muley
Starting Member
2 Posts |
 Posted - 2008-01-14 : 05:50:05
|
| Hello,Kindly help me to resolve the issue with one of my DB maintenance job for Integrity check. This job is failing with following error details.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 437576597,index ID 0,page(1:27593),row 32. Record check(Valid SqlVariant) failed. Vales are 9 and0.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error:Object ID 437576597,index ID 0,page(1:1323919),row 14.Record check (Valid SqlVariant) failed. Values are 9 and 0.[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 2 consistency errors in table 'dta_DebugTrace'(object ID 437576597)I guess this checkdb is failing with the error related to SQLvariant datatype. I don't know actually how to resolve this? can anyone please help me in this.Thanks in advance.Shree |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-15 : 23:56:32
|
| Do you have good backup? |
 |
|
|
shree_muley
Starting Member
2 Posts |
Posted - 2008-01-16 : 06:42:46
|
| Yes I do have a daily bakup for this mentioned db. |
|
|
|
|
|
|
DB maintenance job failing for Integrity Check