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.
| 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 1Page 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 1Table 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. |
 |
|
|
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 helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
|
|
|
|
Msg 8939, Level 16, State 98, Line 1