Post reply

Attempt to fetch logical page (1:440) in database 2 failed. It belongs to allocation unit 422212869292032 not to 6269010747738816512.

  • March 6, 2013 at 12:23 am

    #290388

    hi all,

    One of my sp is giving the following error some times not every time:

    Attempt to fetch logical page (1:440) in database 2 failed. It belongs to allocation unit 422212869292032 not to 6269010747738816512.

    can any one help on this.

    🙂

  • March 6, 2013 at 12:34 am

    #1593796

    TempDB problem...

    Does restarting SQL help? Anyone been shrinking TempDB by any chance?

    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

  • March 6, 2013 at 2:28 am

    #1593832

    GilaMonster (3/6/2013)

    TempDB problem...

    Does restarting SQL help? Anyone been shrinking TempDB by any chance?

    hey thanks, but after restarting the sql server also is giving the same problem. what is happening is after getting this error the query window is disconnecting.

    🙂

  • March 12, 2013 at 1:59 pm

    #1596255

    Please check if your tempDB is being shrunk too regularly? You may have to check auto shrink property of tempdb as well....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • March 12, 2013 at 6:47 pm

    #1596324

    BuntyBoy (3/12/2013)

    Please check if your tempDB is being shrunk too regularly?

    Hopefully this is not the case in anyone's environment as shrinking tempdb is a risky thing to do and there should be no need for it. If tempdb bloats for whatever reason the SQL Server service or entire server can be restarted to safely bring tempdb back to its original size without ever shrinking the database.

    You may have to check auto shrink property of tempdb as well....

    This will not be a concern since we cannot set the auto shrink property on tempdb, even via model.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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