Showing posts with label toobject. Show all posts
Showing posts with label toobject. Show all posts

Sunday, March 11, 2012

Error 605, 823

Does anyone see these errors before? How did you fixed it?
Attempt to fetch logical page (4:27456) in database 'tempdb' belongs to
object '0', not to object '#1AB78AA5'..
Error: 605, Severity: 21, State: 1
... IAM indicates that page is allocated to this object
(4:27456)/(4:27456) 0/448236197
pageno is/should be: objid is/should be:
Getpage: bstat=0x9, sstat=0x4800, cache
I/O error (bad page ID) detected during read at offset 0x000000b6ec4000 in
file 'I:\MSSQL\Data\tempdb1.mdf'..
Error: 823, Severity: 24, State: 2
Thanks,
LijunGeneral recommendations for corrupt or suspect databases:
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Lijun Zhang" <nospam@.nospam.nospam> wrote in message news:usIUpWzdFHA.2736@.TK2MSFTNGP12.phx
.gbl...
> Does anyone see these errors before? How did you fixed it?
> Attempt to fetch logical page (4:27456) in database 'tempdb' belongs to
> object '0', not to object '#1AB78AA5'..
> Error: 605, Severity: 21, State: 1
> ... IAM indicates that page is allocated to this object
> (4:27456)/(4:27456) 0/448236197
> pageno is/should be: objid is/should be:
> Getpage: bstat=0x9, sstat=0x4800, cache
> I/O error (bad page ID) detected during read at offset 0x000000b6ec4000 in
> file 'I:\MSSQL\Data\tempdb1.mdf'..
> Error: 823, Severity: 24, State: 2
>
> Thanks,
> Lijun
>

Error 605, 823

Does anyone see these errors before? How did you fixed it?
Attempt to fetch logical page (4:27456) in database 'tempdb' belongs to
object '0', not to object '#1AB78AA5'..
Error: 605, Severity: 21, State: 1
... IAM indicates that page is allocated to this object
(4:27456)/(4:27456) 0/448236197
pageno is/should be: objid is/should be:
Getpage: bstat=0x9, sstat=0x4800, cache
I/O error (bad page ID) detected during read at offset 0x000000b6ec4000 in
file 'I:\MSSQL\Data\tempdb1.mdf'..
Error: 823, Severity: 24, State: 2
Thanks,
Lijun
General recommendations for corrupt or suspect databases:
http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Lijun Zhang" <nospam@.nospam.nospam> wrote in message news:usIUpWzdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Does anyone see these errors before? How did you fixed it?
> Attempt to fetch logical page (4:27456) in database 'tempdb' belongs to
> object '0', not to object '#1AB78AA5'..
> Error: 605, Severity: 21, State: 1
> ... IAM indicates that page is allocated to this object
> (4:27456)/(4:27456) 0/448236197
> pageno is/should be: objid is/should be:
> Getpage: bstat=0x9, sstat=0x4800, cache
> I/O error (bad page ID) detected during read at offset 0x000000b6ec4000 in
> file 'I:\MSSQL\Data\tempdb1.mdf'..
> Error: 823, Severity: 24, State: 2
>
> Thanks,
> Lijun
>