Post reply

Running DBCC Check on my database

  • May 13, 2013 at 7:51 am

    #273853

    May I please get the correct syntax, I am getting this message,

    Msg 2508, Level 16, State 3, Line 2

    The In-row data RSVD page count for object "BillScanJournal", index ID 1, partition ID 354192345464832, alloc unit ID 354192345464832 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.

    There are 0 rows in 0 pages for object "BillScanJournal".

    CHECKDB found 0 allocation errors and 1 consistency errors in table 'BillScanJournal' (object ID 1109578991).

    DBCC results for 'CnS_MANIFESTCr'.

    I am just new to SQL, much appreciated,

    Regards,

    Bubby

  • May 13, 2013 at 8:50 am

    #1614639

    From BOL -

    USE AdventureWorks2008R2;

    GO

    DBCC UPDATEUSAGE (AdventureWorks2008R2,"HumanResources.Employee");

    GO

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

  • May 13, 2013 at 8:55 am

    #1614642

    You'll want to run it on the database, not a single table, so

    DBCC UPDATEUSAGE(CnS_MANIFESTCr)

    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

  • May 13, 2013 at 9:04 am

    #1614646

    Thanks a Lot for this

  • May 13, 2013 at 9:05 am

    #1614647

    Thanks Gail

Viewing 5 posts - 1 through 4 (of 4 total)

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