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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Attempt to fetch logical page (1:440) in...

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

Rate Topic

Display Mode

Topic Options

Author

Message

SQL*

Posted Wednesday, March 06, 2013 12:23 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:28 PM
Points: 414, Visits: 1,456

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.

Smile

Post #1427203

GilaMonster

Posted Wednesday, March 06, 2013 12:34 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730, Visits: 29,996

TempDB problem...

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1427209

SQL*

Posted Wednesday, March 06, 2013 2:28 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:28 PM
Points: 414, Visits: 1,456

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.

Smile

Post #1427251

BuntyBoy

Posted Tuesday, March 12, 2013 1:59 PM

Old Hand

Group: General Forum Members
Last Login: Saturday, April 27, 2013 9:30 PM
Points: 392, Visits: 384

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

SQL Server Best Practices

Post #1430084

opc.three

Posted Tuesday, March 12, 2013 6:47 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:57 PM
Points: 6,724, Visits: 11,771

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1430170

« Prev Topic | Next Topic »

Permissions