Post reply

suspect_pages for userdefined database

  • October 4, 2011 at 11:55 pm

    #258488

    Hi all,

    When i Use the below command i got the page level error for one datbase

    then how to resolve, i don't know. If any body knows please help me out ?

    use msdb

    go

    select * from suspect_pages

    DBID fileid pageid evettype error count last updatedate

    591213574 1 2009-05-05 12:49:43.293

  • October 5, 2011 at 1:12 am

    #1390516

    Find out what database is number 59 (query sys.databases). Run the following command on that database and post the full and complete output.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply