Allocation Error ??? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Allocation Error ???

Author

Topic

ksewduth
Starting Member

13 Posts

Posted - 2009-09-29 : 04:31:18

Can somebody please explain to me what is an allocation error?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-09-29 : 07:54:15

Some form of damage to a page or a number of pages where the page IDs are wrong, page links are wrong, pages that are referenced can't be found or pages are marked allocated but aren't, or similar.

Is this a theory question or do you have some allocation errors? If the latter, please post he full output of the following command

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

--
Gail Shaw
SQL Server MVP

ksewduth
Starting Member

13 Posts

Posted - 2009-09-30 : 09:47:52

I do have a problem, its the same one you tried to help me out with the other time Gail.

Server: Msg 8906, Level 16, State 1, Line 1
Page (1:12296) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:12519) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:11391) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:54316) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:48528), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
CHECKDB found 1 allocation errors and 0 consistency errors in table 'DAY_CONTROL' (object ID 98151445).
CHECKDB found 1 allocation errors and 0 consistency errors in table 'DAY_DEP_TAX' (object ID 171251765).
CHECKDB found 2 allocation errors and 0 consistency errors in table 'SHIFT_EMP_DATA' (object ID 450100644).
CHECKDB found 4 allocation errors and 0 consistency errors in database 'FrontOff'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FrontOff ).

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-09-30 : 10:05:22

My recommendations remain unchanged from what I posted on the other thread (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132734).

Repair is not fixing this (not sure why) and you have no clean backup. Therefore to get rid of this you need to script all of your objects out, export all the data, drop the database that has the errors and reload everything into a new database.

--
Gail Shaw
SQL Server MVP

ksewduth
Starting Member

13 Posts

Posted - 2009-10-01 : 05:04:37

Thanks Gail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources