"DBCC results for log_shipping_plan_databases." (msdb)

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  May 10, 2004 at 9:10 am

  #85507

  We use Sql 2000 Standard Edition whch doesn't support log shipping. I DBCC'ed the table but to no avail. Unless someone yells "NO" I plan to delete the msdb table 'log_shipping_plan_databases' (which is currently empty), then re-create it.  Can anyone suggest an alternate approach?

  TIA,

   

  Bill

  Error message in LOG file:

  DBCC results for 'log_shipping_plan_databases'.

  Server: Msg 2511, Level 16, State 1, Line 1Error

  Table error: Object ID 146099561, Index ID 2. Keys out of order on page (1:1130), slots 181 and 182.

  There are 0 rows in 0 pages for object 'log_shipping_plan_databases'.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  May 11, 2004 at 6:56 am

  #505954

  Mmm...

  I would first try DBCC CHECKDB or CHECKTABLE with REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS first.

  You should stop the sql Agent before running sp_dboption to put the db in single user mode.

   

  If it doesn't work, then I provable drop and re create those tables.