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
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?
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
