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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Msg 8939, Level 16, State 98, Line 1
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cmchugh
Starting Member

1 Posts

Posted - 09/11/2014 :  11:20:53  Show Profile  Reply with Quote
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 Posts

Posted - 09/13/2014 :  18:24:41  Show Profile  Reply with Quote
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 http://www.datanumen.com/sql-recovery/articles/dbcc-checkdb.htm for more detailed info.

Hope this helps.
Go to Top of Page

Shanky
Yak Posting Veteran

United Kingdom
84 Posts

Posted - 09/16/2014 :  06:57:54  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000