x

Analysis DBCC CHECKDB output

Hello I'am newbie in SQL server

I am using MS SQL server 2000

recently, i saw error on DBCC CEHCKDB message as below


Server: Msg 8946, Level 16, State 12, Line 2                    
Table error: Allocation page (4:32408616) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.                    
Server: Msg 8921, Level 16, State 1, Line 1                    
CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.                    
Server: Msg 8998, Level 16, State 1, Line 1                    
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 9 pages from (4:32408616) to (4:32416703). See other errors for cause.                    
DBCC results for 'qhistoriandata'.                    
CHECKDB found 1 allocation errors and 0 consistency errors not associated with any single object.                    

-----------omit simple info ----------------------

DBCC results for 'sysfulltextcatalogs'.                    
Server: Msg 8939, Level 16, State 98, Line 1                    
Table error: Object ID 99, index ID 0, page (4:32408616). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.                    
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.                    

-----------omit simple info ----------------------

DBCC results for 'sysfilegroups'.                    
There are 2 rows in 1 pages for object 'sysfilegroups'.                    
CHECKDB found 0 allocation errors and 1 consistency errors in table 'ALLOCATION' (object ID 99).                    

-----------omit simple info ----------------------

CHECKDB found 1 allocation errors and 1 consistency errors in database 'QHistorianData'.                    
DBCC execution completed. If DBCC printed error messages, contact your system administrator.                    


so, i excuted DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS option but i couldn't fix this error wih "the system cannot self repair this error"

so i am going to do someting as below

  1. i have backed up BAK file that has same problem of current active database. so i will make new DB . then, i want transfer validated data into it from backed up BAK file. so is it available?

  2. for fixing this error, i will analysis DBCC output message, but i can't understand this message. i want what table or view has corruption. what is object ID, page id(?:????????) and so on. so let me know how to understand this message?

I appreciate you for reading this post

if you give me some tips, it will be too much help for me.

thank you

more ▼

asked Nov 20, 2009 at 12:26 AM in Default

FOX gravatar image

FOX
1 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Those numbers correspond to the physical file and page number within the file which are corrupt.

more ▼

answered Nov 30, 2009 at 04:38 AM

mrdenny gravatar image

mrdenny
928 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x474
x192
x102
x47
x15

asked: Nov 20, 2009 at 12:26 AM

Seen: 2260 times

Last Updated: Nov 20, 2009 at 12:54 AM