Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    12

    Unanswered: MSDB problems during verify

    This is the error from Commvault :

    2492341 [bwcimsdb1/SQLiDA] [01/21/2009 06:52:31 ]: Error encountered during backup. Error: [ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Time-out occurred while waiting for buffer latch type 4 for page (1:2515), database ID 4. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE successfully processed 3141483 pages in 439.343 seconds (58.576 MB/sec). [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated

    In the native maint plan can't get past the integrity check on msdb ... I ran this query (DBCC CHECKDB('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS) and got the following but not sure I understand what it's telling me ...

    Msg 8929, Level 16, State 1, Line 1
    Object ID 949578421, index ID 0, partition ID 72057594042253312, alloc unit ID 72057594046513152 (type In-row data): Errors found in off-row data with ID 523042816 owned by data record identified by RID = (1:1523:1)
    Msg 8929, Level 16, State 1, Line 1
    Object ID 949578421, index ID 0, partition ID 72057594042253312, alloc unit ID 72057594046513152 (type In-row data): Errors found in off-row data with ID 768606208 owned by data record identified by RID = (1:1525:0)
    Msg 8914, Level 16, State 1, Line 1
    Incorrect PFS free space information for page (1:1665) in object ID 949578421, index ID 0, partition ID 72057594042253312, alloc unit ID 72057594046513152 (type In-row data). Expected value 0_PCT_FULL, actual value 50_PCT_FULL.
    Msg 8914, Level 16, State 1, Line 1
    Incorrect PFS free space information for page (1:1667) in object ID 949578421, index ID 0, partition ID 72057594042253312, alloc unit ID 72057594046513152 (type In-row data). Expected value 0_PCT_FULL, actual value 50_PCT_FULL.
    Msg 8914, Level 16, State 1, Line 1

  2. #2
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •