DB CORRUPTION "Error: 15457, Severity: 0, State: 1

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

General SQL Server Forums

Data Corruption Issues

DB CORRUPTION "Error: 15457, Severity: 0, State: 1

Author

Topic

sqlserverdba
Yak Posting Veteran

53 Posts

Posted - 2008-10-03 : 15:22:57

Hi All,

I've been getting follwoing message in sql server(sqlserver 2000) log.

1)First Message
"Configuration option 'show advanced options' changed from 1 to 1. Run the RECON
Error: 15457, Severity: 0, State: 1
Configuration option 'show advanced options' changed from 1 to 1. Run the RECON
Error: 15457, Severity: 0, State: 1"

2)Second Message
backup Log backed up: Database: MDXF, creation date(time): 2007/03/20(19:28:30), first

I/O error (bad page ID) detected during read at offset 0x000001390c0000 in file
Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset 0x0000013714a000 in file
Error: 823, Severity: 24, State: 2

Please advice.
Thanks,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-03 : 15:39:04

Post the entire output of DBCC CHECKDB for database MDXF.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sqlserverdba
Yak Posting Veteran

53 Posts

Posted - 2008-10-03 : 15:50:30

Here you go.

DBCC CHECKDB (IDXwf) executed by ahssa found 48 errors and repaired 0 errors.

thanks,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-03 : 15:52:21

We need the entire output not just the message.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sqlserverdba
Yak Posting Veteran

53 Posts

Posted - 2008-10-03 : 15:55:31

Any clue?

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-10-03 : 17:16:20

quote:
Originally posted by sqlserverdba

Any clue?

Do you? tara asked for the entire set of messages that the checkdb generated. Run DBCC CHECKDB WITH NO_INFOMSGS, All_Errormsgs and post them here for any meaningful help.

Terry

sqlserverdbam
Yak Posting Veteran

54 Posts

Posted - 2008-10-05 : 12:30:51

Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -791562422, index ID 0, page ID (1:637109). The PageId in the page header = (3:816).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -791562422, index ID 1, page ID (1:637110). The PageId in the page header = (3:817).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -743562251, index ID 0, page ID (1:637093). The PageId in the page header = (3:800).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -743562251, index ID 0, page ID (1:637101). The PageId in the page header = (3:808).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -743562251, index ID 1, page ID (1:637094). The PageId in the page header = (3:801).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -743562251, index ID 1, page ID (1:637102). The PageId in the page header = (3:809).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637095). The PageId in the page header = (3:802).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637096). The PageId in the page header = (3:803).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637097). The PageId in the page header = (3:804).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637098). The PageId in the page header = (3:805).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637099). The PageId in the page header = (3:806).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637100). The PageId in the page header = (3:807).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637103). The PageId in the page header = (3:810).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637104). The PageId in the page header = (3:811).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637105). The PageId in the page header = (3:812).
CHECKDB found 0 allocation errors and 2 consistency errors in table '(Object ID -791562422)' (object ID -791562422).
CHECKDB found 0 allocation errors and 4 consistency errors in table '(Object ID -743562251)' (object ID -743562251).
DBCC results for 'IDXwf'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637106). The PageId in the page header = (3:813).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637107). The PageId in the page header = (3:814).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637108). The PageId in the page header = (3:815).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637111). The PageId in the page header = (3:818).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637112). The PageId in the page header = (3:819).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:637113). The PageId in the page header = (3:820).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:642312). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:642313). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:642314). The PageId in the page header = (0:0).
CHECKDB found 0 allocation errors and 18 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 451 rows in 8 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 255 rows in 12 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1561 rows in 31 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 305 rows in 128 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 470 rows in 2 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 19 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637093) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637094) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637095) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637096) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637097) could not be processed. See other errors for details.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 3177 rows in 18 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 130 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'Document'.
There are 777 rows in 15 pages for object 'Document'.
DBCC results for 'DocumentSecurity'.
There are 0 rows in 0 pages for object 'DocumentSecurity'.
DBCC results for 'Entity'.
There are 0 rows in 0 pages for object 'Entity'.
DBCC results for 'EntityMap'.
There are 0 rows in 0 pages for object 'EntityMap'.
DBCC results for 'EntityType'.
There are 0 rows in 0 pages for object 'EntityType'.
DBCC results for 'EntityTypeMap'.
There are 0 rows in 0 pages for object 'EntityTypeMap'.
DBCC results for 'EventLog'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637098) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637099) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637100) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637101) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637102) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637103) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637104) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637105) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637106) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637107) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637108) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637109) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637110) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637111) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637112) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:637113) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:642312) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:642313) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 213575799, index ID 0: Page (1:642314) could not be processed. See other errors for details.
There are 54325538 rows in 907001 pages for object 'EventLog'.
CHECKDB found 0 allocation errors and 24 consistency errors in table 'EventLog' (object ID 213575799).
DBCC results for 'Menu'.
There are 165 rows in 3 pages for object 'Menu'.
DBCC results for 'MenuActivity'.
There are 0 rows in 0 pages for object 'MenuActivity'.
DBCC results for 'MenuDocument'.
There are 412 rows in 4 pages for object 'MenuDocument'.
DBCC results for 'MenuLink'.
There are 254 rows in 3 pages for object 'MenuLink'.
DBCC results for 'MenuScript'.
There are 19 rows in 1 pages for object 'MenuScript'.
DBCC results for 'MenuSecurity'.
There are 0 rows in 0 pages for object 'MenuSecurity'.
DBCC results for 'MenuType'.
There are 6 rows in 1 pages for object 'MenuType'.
DBCC results for 'Parameter'.
There are 0 rows in 0 pages for object 'Parameter'.
DBCC results for 'Preference'.
There are 338 rows in 5 pages for object 'Preference'.
DBCC results for 'Product'.
There are 5 rows in 1 pages for object 'Product'.
DBCC results for 'ProductApplication'.
There are 22 rows in 1 pages for object 'ProductApplication'.
DBCC results for 'Rights'.
There are 65 rows in 1 pages for object 'Rights'.
DBCC results for 'RightLink'.
There are 94 rows in 1 pages for object 'RightLink'.
DBCC results for 'ProductSecurity'.
There are 0 rows in 0 pages for object 'ProductSecurity'.
DBCC results for 'Script'.
There are 19 rows in 1 pages for object 'Script'.
DBCC results for 'ScriptSecurity'.
There are 0 rows in 0 pages for object 'ScriptSecurity'.
DBCC results for 'Security'.
There are 1 rows in 1 pages for object 'Security'.
DBCC results for 'System'.
There are 4 rows in 1 pages for object 'System'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'CHPHBProdAppParameter'.
There are 12 rows in 1 pages for object 'CHPHBProdAppParameter'.
DBCC results for 'SystemApplication'.
There are 10 rows in 1 pages for object 'SystemApplication'.
DBCC results for 'CHPHBUserSysProdAppParameter'.
There are 13 rows in 2 pages for object 'CHPHBUserSysProdAppParameter'.
DBCC results for 'CHPHBUserCMELog'.
There are 0 rows in 0 pages for object 'CHPHBUserCMELog'.
DBCC results for 'SystemPreference'.
There are 112 rows in 1 pages for object 'SystemPreference'.
DBCC results for 'CHPHBUsers'.
There are 4 rows in 1 pages for object 'CHPHBUsers'.
DBCC results for 'CHPHBComponent'.
There are 55 rows in 1 pages for object 'CHPHBComponent'.
DBCC results for 'SystemProduct'.
There are 9 rows in 1 pages for object 'SystemProduct'.
DBCC results for 'CHPHBProductSection'.
There are 5 rows in 1 pages for object 'CHPHBProductSection'.
DBCC results for 'CHPHBSection'.
There are 5 rows in 1 pages for object 'CHPHBSection'.
DBCC results for 'SystemSecurity'.
There are 0 rows in 0 pages for object 'SystemSecurity'.
DBCC results for 'CHPHBSectionComponent'.
There are 38 rows in 1 pages for object 'CHPHBSectionComponent'.
DBCC results for 'CHPHBUserSection'.
There are 12 rows in 1 pages for object 'CHPHBUserSection'.
DBCC results for 'Target'.
There are 17 rows in 1 pages for object 'Target'.
DBCC results for 'CHPHBUserSectionComponent'.
There are 80 rows in 1 pages for object 'CHPHBUserSectionComponent'.
DBCC results for 'CHPHBSysComponentDetail'.
There are 295 rows in 4 pages for object 'CHPHBSysComponentDetail'.
DBCC results for 'TargetLookup'.
There are 1 rows in 1 pages for object 'TargetLookup'.
DBCC results for 'CHPHBUserSysCompDetail'.
There are 212 rows in 3 pages for object 'CHPHBUserSysCompDetail'.
DBCC results for 'Users'.
There are 721 rows in 26 pages for object 'Users'.
DBCC results for 'CHPHBRegWebMDSpecialty'.
There are 126 rows in 1 pages for object 'CHPHBRegWebMDSpecialty'.
DBCC results for 'UserEntity'.
There are 0 rows in 0 pages for object 'UserEntity'.
DBCC results for 'UserPreference'.
There are 3052 rows in 24 pages for object 'UserPreference'.
DBCC results for 'UserProxy'.
There are 0 rows in 0 pages for object 'UserProxy'.
DBCC results for 'Color'.
There are 2987 rows in 19 pages for object 'Color'.
DBCC results for 'UserRight'.
There are 726 rows in 5 pages for object 'UserRight'.
DBCC results for 'Device'.
There are 0 rows in 0 pages for object 'Device'.
DBCC results for 'UserSecurity'.
There are 0 rows in 0 pages for object 'UserSecurity'.
DBCC results for 'DevicePreference'.
There are 0 rows in 0 pages for object 'DevicePreference'.
DBCC results for 'UserSystem'.
There are 679 rows in 6 pages for object 'UserSystem'.
DBCC results for 'Jobs'.
There are 4 rows in 1 pages for object 'Jobs'.
DBCC results for 'UserSystemApplication'.
There are 732 rows in 8 pages for object 'UserSystemApplication'.
DBCC results for 'AHSProduct'.
There are 10 rows in 1 pages for object 'AHSProduct'.
DBCC results for 'Palette'.
There are 12 rows in 1 pages for object 'Palette'.
DBCC results for 'UserSystemApplicationParameter'.
There are 0 rows in 0 pages for object 'UserSystemApplicationParameter'.
DBCC results for 'DocumentAHSProduct'.
There are 42 rows in 1 pages for object 'DocumentAHSProduct'.
DBCC results for 'Server'.
There are 0 rows in 0 pages for object 'Server'.
DBCC results for 'UserSystemTarget'.
There are 0 rows in 0 pages for object 'UserSystemTarget'.
DBCC results for 'Maint_Space_Used'.
There are 1821 rows in 37 pages for object 'Maint_Space_Used'.
DBCC results for 'ErrorLog'.
There are 0 rows in 0 pages for object 'ErrorLog'.
DBCC results for 'Device_Audit'.
There are 0 rows in 0 pages for object 'Device_Audit'.
DBCC results for 'DeviceSystem'.
There are 0 rows in 0 pages for object 'DeviceSystem'.
DBCC results for 'Bulk_Load_Users'.
There are 0 rows in 0 pages for object 'Bulk_Load_Users'.
DBCC results for 'CHPHBBulk_Load_Users'.
There are 0 rows in 0 pages for object 'CHPHBBulk_Load_Users'.
DBCC results for 'PaletteConfigSetting'.
There are 496 rows in 8 pages for object 'PaletteConfigSetting'.
DBCC results for 'PaletteConfigSet'.
There are 3 rows in 1 pages for object 'PaletteConfigSet'.
DBCC results for 'Session'.
There are 52 rows in 27 pages for object 'Session'.
DBCC results for 'Application'.
There are 20 rows in 1 pages for object 'Application'.
DBCC results for 'ApplicationParameter'.
There are 0 rows in 0 pages for object 'ApplicationParameter'.
DBCC results for 'ApplicationSecurity'.
There are 0 rows in 0 pages for object 'ApplicationSecurity'.
DBCC results for 'ApplicationTarget'.
There are 2 rows in 1 pages for object 'ApplicationTarget'.
DBCC results for 'ChartSummary'.
There are 0 rows in 0 pages for object 'ChartSummary'.
DBCC results for 'ChartSummaryDocument'.
There are 0 rows in 0 pages for object 'ChartSummaryDocument'.
CHECKDB found 0 allocation errors and 48 consistency errors in database 'IDXwf'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (IDXwf ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources