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 |
|
kowani1
Starting Member
42 Posts |
 Posted - 2007-07-30 : 01:33:18
|
| Hi,I am trying to execute a maintenance plan to backup the db's data and log files as well as do integrity checks but am getting the following error.i.e. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8929: [Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 1701581100: Errors found in text ID 5459804160 owned by data record identified by RID = (1:30649:89). Does anyone know how I can resolve this??Thanks. Jungle DBA |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2007-07-30 : 02:05:36
|
| Determine what object is 1701581100. Check inconsistencies on rowid 89, page# 30649, fileid 1.Donn Policarpio |
 |
|
|
kowani1
Starting Member
42 Posts |
Posted - 2007-07-30 : 02:18:13
|
| could you please give me more info on how I can "Determine what object is 1701581100. Check inconsistencies on rowid 89, page# 30649, fileid 1." as you have suggested, as I am not too familiar with this error. |
|
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2007-07-30 : 02:28:54
|
| On the database, Select object_id(1701581100), select fileid from sysfiles. You may also want to run dbcc checktable using a repair option.Donn Policarpio |
|
|
|
|
|
|
Maintenance Plan Execution Errors