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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Msg 8939, Level 16, State 98, Line 1

Author  Topic 

cmchugh
Starting Member

1 Post

Posted - 2014-09-11 : 11:20:53
I am having problems with the error below for my company ERP system. I am currently trying to determine the cause and also a way to restore to a good state. My most recent backup still had gave this error so I am concerned going further back and what it will do to our business. Any advise or guidance on how to resolve with minimal data lose?

Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 7 pages from (1:8686512) to (1:9204143). See other errors for cause.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 281474983198720 (type Unknown), page (1:8690945). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 197265417 and -4.
CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB found 2 allocation errors and 0 consistency errors in database 'AX42_CSN_DB_PROD'.

alice198723
Starting Member

1 Post

Posted - 2014-09-13 : 18:24:41
GAM, SGAM and PFS pages are all allocation pages, not data pages. It seems that there are some problems with these pages. The problems are not fatal.

What I will suggest you to do is:

1. Backup of your database.

2. Switch to single user mode and try to run checkdb with parameter REPAIR_REBUILD to see if it will fix the error. See [url]http://www.datanumen.com/sql-recovery/articles/dbcc-checkdb.htm[/url] for more detailed info.

Hope this helps.
Go to Top of Page

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-09-16 : 06:57:54
Please dont follow above suggestion. You can restore database with valid recent backup. These tools are waste I have feedback for it.

Hope this helps

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -