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 |
|
thombeaux
Starting Member
18 Posts |
 Posted - 2007-05-22 : 11:59:03
|
| We have been recieving data corruption errors:Server: Msg 8928, Level 16, State 1, Line 1Object ID 650485396, index ID 255: Page (1:5426420) could not be processed. See other errors for details.DBCC results for 'LTINTERVENTIONS'.There are 739501 rows in 37787 pages for object 'LTINTERVENTIONS'.CHECKDB found 0 allocation errors and 1 consistency errors in table 'LTINTERVENTIONS' (object ID 650485396).This error has cleared up without any CheckTable repair, but the same sort of error appears on other tables.I restore a backup (last night backup 7:30PM - CheckDB reported errors) from the database unto another server, ran CheckDB, and no errors.Is the data file corrupted? Can I delete the data file and restore from a backup?The system is Windows 2003 Server (latest SP), SQL Server 2000 (SP3a) and we have a SAN with RAID 10 arrays for the drives. The errors are appearing on 2 different drives on 2 different databases.The CheckDB on Sunday shows errors on tables that now have no errors on the CheckDB from last night, but last night's CheckDB has different tables with errors.The errors logs on the server only show Application SQL errors, no system errors.Thanks,ThomBeaxThomBeaux |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-05-22 : 12:19:20
|
| Can you post all the sets of CHECKDB output (in a timeline)?Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
 |
|
|
thombeaux
Starting Member
18 Posts |
Posted - 2007-05-22 : 13:47:13
|
| We recieved this error today (on both DBs-SQL Log):-Error: 823, Severity: 24, State: 2-I/O error (bad page ID) detected during read at offset 0x00000cb0bb8000 in file 'M:\SQLData\POC_Data.MDF'..Last Night CheckDB: (I took out the rows that were OK and left the sys tables)Job 'CheckDB_Prod64_POC' : Step 3, 'Step2_CheckDBPOC' : Began Executing 2007-05-22 01:05:30DBCC results for 'POC'. [SQLSTATE 01000]DBCC results for 'sysobjects'. [SQLSTATE 01000]There are 702 rows in 26 pages for object 'sysobjects'. [SQLSTATE 01000]DBCC results for 'sysindexes'. [SQLSTATE 01000]There are 1096 rows in 54 pages for object 'sysindexes'. [SQLSTATE 01000]DBCC results for 'syscolumns'. [SQLSTATE 01000]There are 11180 rows in 237 pages for object 'syscolumns'. [SQLSTATE 01000]DBCC results for 'systypes'. [SQLSTATE 01000]There are 26 rows in 1 pages for object 'systypes'. [SQLSTATE 01000]DBCC results for 'syscomments'. [SQLSTATE 01000]There are 425 rows in 35 pages for object 'syscomments'. [SQLSTATE 01000]DBCC results for 'sysfiles1'. [SQLSTATE 01000]There are 2 rows in 1 pages for object 'sysfiles1'. [SQLSTATE 01000]DBCC results for 'syspermissions'. [SQLSTATE 01000]There are 26 rows in 1 pages for object 'syspermissions'. [SQLSTATE 01000]DBCC results for 'sysusers'. [SQLSTATE 01000]There are 17 rows in 1 pages for object 'sysusers'. [SQLSTATE 01000]DBCC results for 'sysproperties'. [SQLSTATE 01000]There are 30 rows in 1 pages for object 'sysproperties'. [SQLSTATE 01000]DBCC results for 'sysdepends'. [SQLSTATE 01000]There are 3070 rows in 20 pages for object 'sysdepends'. [SQLSTATE 01000]DBCC results for 'sysreferences'. [SQLSTATE 01000]There are 0 rows in 0 pages for object 'sysreferences'. [SQLSTATE 01000]DBCC results for 'sysfulltextcatalogs'. [SQLSTATE 01000]There are 0 rows in 0 pages for object 'sysfulltextcatalogs'. [SQLSTATE 01000]DBCC results for 'sysfulltextnotify'. [SQLSTATE 01000]There are 0 rows in 0 pages for object 'sysfulltextnotify'. [SQLSTATE 01000]DBCC results for 'sysfilegroups'. [SQLSTATE 01000]There are 1 rows in 1 pages for object 'sysfilegroups'. [SQLSTATE 01000]DBCC results for 'LTTHERO9'. [SQLSTATE 01000]There are 91924 rows in 4940 pages for object 'LTTHERO9'. [SQLSTATE 01000]DBCC results for 'LTAGENCY'. [SQLSTATE 01000]Msg 8909, Sev 16: Table error: Object ID 614657633, index ID 0, page ID (1:5079060). The PageId in the page header = (1:11609505). [SQLSTATE 42000]Msg 2593, Sev 16: There are 162031 rows in 3532 pages for object 'LTAGENCY'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTTHROAT'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 667065 rows in 27126 pages for object 'LTTHROAT'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTALLERGIES'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 109376 rows in 1986 pages for object 'LTALLERGIES'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTTIMER'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 3331301 rows in 28086 pages for object 'LTTIMER'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTAPP1'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 109376 rows in 11011 pages for object 'LTAPP1'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTVISFORM'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 2966848 rows in 38247 pages for object 'LTVISFORM'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTASUPERVISORY'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 68442 rows in 6360 pages for object 'LTASUPERVISORY'. [SQLSTATE 01000]Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 614657633)' (object ID 614657633). [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTVISION'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 706261 rows in 34835 pages for object 'LTVISION'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTCARDIO2'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'LTCARDIO2'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTINTERVENTIONS'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 739817 rows in 37806 pages for object 'LTINTERVENTIONS'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTCARDIO3'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 142512 rows in 6828 pages for object 'LTCARDIO3'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTWOUND1'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'LTWOUND1'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTCAREC1'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'LTCAREC1'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTWOUND2'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 142506 rows in 2758 pages for object 'LTWOUND2'. [SQLSTATE 01000]DBCC results for 'LTLIVING6'. [SQLSTATE 01000]There are 0 rows in 0 pages for object 'LTLIVING6'. [SQLSTATE 01000]Msg 8928, Sev 16: Object ID 1634820886, index ID 255: Page (1:5079060) could not be processed. See other errors for details. [SQLSTATE 42000]Msg 2536, Sev 16: DBCC results for 'LTMEDHIST1'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 105152 rows in 3277 pages for object 'LTMEDHIST1'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTMEDHIST2'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 98651 rows in 3302 pages for object 'LTMEDHIST2'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTENDOCRINE'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 722471 rows in 241212 pages for object 'LTENDOCRINE'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTMEDHIST3'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'LTMEDHIST3'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTMEDHIST4'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 109346 rows in 9953 pages for object 'LTMEDHIST4'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTEXPORTS'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 7447 rows in 38 pages for object 'LTEXPORTS'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTMEDHIST5'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 142515 rows in 1881 pages for object 'LTMEDHIST5'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'ltmsword'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 595 rows in 15 pages for object 'ltmsword'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTMEDICATIONS'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 663020 rows in 49883 pages for object 'LTMEDICATIONS'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'frmreqlink'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 34 rows in 1 pages for object 'frmreqlink'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTMEDICATIONS2'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 65099 rows in 2443 pages for object 'LTMEDICATIONS2'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTWOUND'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 187122 rows in 13292 pages for object 'LTWOUND'. [SQLSTATE 01000]Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 1 consistency errors in table 'LTWOUND' (object ID 1634820886). [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'ltWoundVAC'. [SQLSTATE 01000]Msg 2593, Sev 16: There are 737 rows in 91 pages for object 'ltWoundVAC'. [SQLSTATE 01000]Msg 2536, Sev 16: DBCC results for 'LTMEDICATIONS3'. [SQLSTATE 01000]There are 98654 rows in 5296 pages for object 'LTMEDICATIONS3'. [SQLSTATE 01000]CHECKDB found 0 allocation errors and 2 consistency errors in database 'POC'. [SQLSTATE 01000]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (POC ). [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]CheckDB on the other server, after Restore of Backup (all tables)DBCC results for 'POCTest'.DBCC results for 'sysobjects'.There are 702 rows in 26 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 1096 rows in 54 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 11180 rows in 230 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 425 rows in 35 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 26 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 17 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 30 rows in 1 pages for object 'sysproperties'.DBCC results for 'sysdepends'.There are 3070 rows in 20 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 0 rows in 0 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 'LTREHABP2'.There are 132793 rows in 1771 pages for object 'LTREHABP2'.DBCC results for 'LTREHABP3'.There are 2 rows in 1 pages for object 'LTREHABP3'.DBCC results for 'LTSAFMEAS'.There are 109344 rows in 3893 pages for object 'LTSAFMEAS'.DBCC results for 'LTSIGNATURE'.There are 0 rows in 0 pages for object 'LTSIGNATURE'.DBCC results for 'LTSIGNATURE2'.There are 0 rows in 0 pages for object 'LTSIGNATURE2'.DBCC results for 'LTFUNC1'.There are 109344 rows in 2297 pages for object 'LTFUNC1'.DBCC results for 'LTSPEECH1'.There are 98624 rows in 1316 pages for object 'LTSPEECH1'.DBCC results for 'LTACT1'.There are 109344 rows in 2436 pages for object 'LTACT1'.DBCC results for 'LTTRANSFERLOG'.There are 3725 rows in 59 pages for object 'LTTRANSFERLOG'.DBCC results for 'LTSYSTEMR'.There are 1089799 rows in 55316 pages for object 'LTSYSTEMR'.DBCC results for 'LTTHERAPY'.There are 105118 rows in 1339 pages for object 'LTTHERAPY'.DBCC results for 'LTTHERO10'.There are 91958 rows in 1951 pages for object 'LTTHERO10'.DBCC results for 'LTTHERO11'.There are 91958 rows in 4767 pages for object 'LTTHERO11'.DBCC results for 'LTTHERO12'.There are 91956 rows in 2816 pages for object 'LTTHERO12'.DBCC results for 'ltptinter'.There are 270741 rows in 7840 pages for object 'ltptinter'.DBCC results for 'LTTHERO13'.There are 91958 rows in 3426 pages for object 'LTTHERO13'.DBCC results for 'LTTHERO14'.There are 91956 rows in 2211 pages for object 'LTTHERO14'.DBCC results for 'LTTHERO15'.There are 0 rows in 0 pages for object 'LTTHERO15'.DBCC results for 'LTTHERO16'.There are 0 rows in 0 pages for object 'LTTHERO16'.DBCC results for 'LTTHERO17'.There are 2 rows in 1 pages for object 'LTTHERO17'.DBCC results for 'LTTHERO18'.There are 0 rows in 0 pages for object 'LTTHERO18'.DBCC results for 'LTTHERO19'.There are 0 rows in 0 pages for object 'LTTHERO19'.DBCC results for 'LTTHERO1'.There are 91954 rows in 2989 pages for object 'LTTHERO1'.DBCC results for 'LTTHERO2'.There are 91958 rows in 1449 pages for object 'LTTHERO2'.DBCC results for 'ltpsyc1'.There are 60607 rows in 30193 pages for object 'ltpsyc1'.DBCC results for 'LTTHERO20'.There are 0 rows in 0 pages for object 'LTTHERO20'.DBCC results for 'ltpsyc2'.There are 60607 rows in 30192 pages for object 'ltpsyc2'.DBCC results for 'LTTHERO21'.There are 0 rows in 0 pages for object 'LTTHERO21'.DBCC results for 'ltnutpainord'.There are 90454 rows in 4197 pages for object 'ltnutpainord'.DBCC results for 'LTSKIN'.There are 733264 rows in 15039 pages for object 'LTSKIN'.DBCC results for 'LTTHERO22'.There are 0 rows in 0 pages for object 'LTTHERO22'.DBCC results for 'LTTHERO23'.There are 2 rows in 1 pages for object 'LTTHERO23'.DBCC results for 'LTEMOTIONAL'.There are 739549 rows in 130731 pages for object 'LTEMOTIONAL'.DBCC results for 'LTTHERO3'.There are 91956 rows in 2387 pages for object 'LTTHERO3'.DBCC results for 'LTABDOMEN'.There are 142466 rows in 4043 pages for object 'LTABDOMEN'.DBCC results for 'LTNEUROMUSCULAR'.There are 722184 rows in 54705 pages for object 'LTNEUROMUSCULAR'.DBCC results for 'LTTHERO4'.There are 91956 rows in 3018 pages for object 'LTTHERO4'.DBCC results for 'LTCARDIO'.There are 1089469 rows in 133935 pages for object 'LTCARDIO'.DBCC results for 'LTPATO'.There are 19 rows in 1 pages for object 'LTPATO'.DBCC results for 'LTTHERO6'.There are 91955 rows in 3699 pages for object 'LTTHERO6'.DBCC results for 'LTADL1'.There are 142470 rows in 11821 pages for object 'LTADL1'.DBCC results for 'LTTHERO7'.There are 91956 rows in 1422 pages for object 'LTTHERO7'.DBCC results for 'LTADL2'.There are 142470 rows in 12794 pages for object 'LTADL2'.DBCC results for 'LTTHERO8'.There are 91958 rows in 1635 pages for object 'LTTHERO8'.DBCC results for 'LTADL3'.There are 98622 rows in 1816 pages for object 'LTADL3'.DBCC results for 'LTTHERO9'.There are 91894 rows in 4939 pages for object 'LTTHERO9'.DBCC results for 'LTAGENCY'.There are 161989 rows in 3529 pages for object 'LTAGENCY'.DBCC results for 'LTTHROAT'.There are 666774 rows in 27112 pages for object 'LTTHROAT'.DBCC results for 'LTALLERGIES'.There are 109344 rows in 1986 pages for object 'LTALLERGIES'.DBCC results for 'LTTIMER'.There are 3329157 rows in 28068 pages for object 'LTTIMER'.DBCC results for 'LTAPP1'.There are 109344 rows in 11009 pages for object 'LTAPP1'.DBCC results for 'LTVISFORM'.There are 2965600 rows in 38230 pages for object 'LTVISFORM'.DBCC results for 'LTASUPERVISORY'.There are 68413 rows in 6358 pages for object 'LTASUPERVISORY'.DBCC results for 'LTVISION'.There are 705958 rows in 34828 pages for object 'LTVISION'.DBCC results for 'LTCARDIO2'.There are 0 rows in 0 pages for object 'LTCARDIO2'.DBCC results for 'LTINTERVENTIONS'.There are 739501 rows in 37787 pages for object 'LTINTERVENTIONS'.DBCC results for 'LTCARDIO3'.There are 142470 rows in 6826 pages for object 'LTCARDIO3'.DBCC results for 'LTWOUND1'.There are 0 rows in 0 pages for object 'LTWOUND1'.DBCC results for 'LTCAREC1'.There are 0 rows in 0 pages for object 'LTCAREC1'.DBCC results for 'LTWOUND2'.There are 142464 rows in 2757 pages for object 'LTWOUND2'.DBCC results for 'LTCAREC2'.There are 0 rows in 0 pages for object 'LTCAREC2'.DBCC results for 'LTWOUND3'.There are 142464 rows in 2747 pages for object 'LTWOUND3'.DBCC results for 'LTCAREP2'.There are 301495 rows in 30260 pages for object 'LTCAREP2'.DBCC results for 'LTWOUND4'.There are 187031 rows in 24966 pages for object 'LTWOUND4'.DBCC results for 'LTCAREP3'.There are 69608 rows in 5506 pages for object 'LTCAREP3'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'LTCAREP4'.There are 12739 rows in 1053 pages for object 'LTCAREP4'.DBCC results for 'LTCAREP5'.There are 9240 rows in 1839 pages for object 'LTCAREP5'.DBCC results for 'LTCAREP6'.There are 704753 rows in 162798 pages for object 'LTCAREP6'.DBCC results for 'LTCARES1'.There are 130816 rows in 11584 pages for object 'LTCARES1'.DBCC results for 'LTCARES3'.There are 20277 rows in 475 pages for object 'LTCARES3'.DBCC results for 'LTCARES4'.There are 110931 rows in 2397 pages for object 'LTCARES4'.DBCC results for 'LTCASEC1'.There are 0 rows in 0 pages for object 'LTCASEC1'.DBCC results for 'frmhdr'.There are 32 rows in 1 pages for object 'frmhdr'.DBCC results for 'LTDIRECT'.There are 105115 rows in 2549 pages for object 'LTDIRECT'.DBCC results for 'frmdet'.There are 724 rows in 25 pages for object 'frmdet'.DBCC results for 's_CaseConf'.There are 64742 rows in 1281 pages for object 's_CaseConf'.DBCC results for 'LTDISCHARGEP'.There are 136650 rows in 3036 pages for object 'LTDISCHARGEP'.DBCC results for 'CLSCHUNK'.There are 11162 rows in 176 pages for object 'CLSCHUNK'.DBCC results for 's_ClinAssess'.There are 0 rows in 0 pages for object 's_ClinAssess'.DBCC results for 'LTDISCHARGET'.There are 57938 rows in 4781 pages for object 'LTDISCHARGET'.DBCC results for 'LTREHABP1'.There are 1092331 rows in 38830 pages for object 'LTREHABP1'.DBCC results for 's_ClinInd'.There are 732254 rows in 11271 pages for object 's_ClinInd'.DBCC results for 'LTEARS'.There are 666752 rows in 22820 pages for object 'LTEARS'.DBCC results for 'ltClinTrack'.There are 480825 rows in 10595 pages for object 'ltClinTrack'.DBCC results for 'ltforceupdate'.There are 1 rows in 1 pages for object 'ltforceupdate'.DBCC results for 'LTELIMINATION'.There are 0 rows in 0 pages for object 'LTELIMINATION'.DBCC results for 'ltaddress'.There are 0 rows in 0 pages for object 'ltaddress'.DBCC results for 's_DCsum'.There are 48942 rows in 1028 pages for object 's_DCsum'.DBCC results for 's_TranfSum'.There are 17678 rows in 411 pages for object 's_TranfSum'.DBCC results for 's_ltVersion'.There are 1065 rows in 4 pages for object 's_ltVersion'.DBCC results for 'LTFALLS1'.There are 109344 rows in 1916 pages for object 'LTFALLS1'.DBCC results for 's_ltscheduleque'.There are 3 rows in 1 pages for object 's_ltscheduleque'.DBCC results for 'LTENTERAL'.There are 0 rows in 0 pages for object 'LTENTERAL'.DBCC results for 's_ltupdateque'.There are 0 rows in 1 pages for object 's_ltupdateque'.DBCC results for 'LTENTERNAL'.There are 728216 rows in 68025 pages for object 'LTENTERNAL'.DBCC results for 'LTENVIRON1'.There are 128851 rows in 1693 pages for object 'LTENVIRON1'.DBCC results for 'LTENVIRON2'.There are 65080 rows in 2150 pages for object 'LTENVIRON2'.DBCC results for 'lttrkhdr'.There are 1719731 rows in 21124 pages for object 'lttrkhdr'.DBCC results for 'amhdr'.There are 9039 rows in 385 pages for object 'amhdr'.DBCC results for 'LTEQUIP1'.There are 98622 rows in 1464 pages for object 'LTEQUIP1'.DBCC results for 'LTTHERO24'.There are 18562 rows in 2680 pages for object 'LTTHERO24'.DBCC results for 'LTGASTRO'.There are 728213 rows in 150028 pages for object 'LTGASTRO'.DBCC results for 'LTGENITA1'.There are 65080 rows in 10783 pages for object 'LTGENITA1'.DBCC results for 'MSTASK'.There are 82275 rows in 2499 pages for object 'MSTASK'.DBCC results for 'ltptsum'.There are 32828 rows in 919 pages for object 'ltptsum'.DBCC results for 'LTGENITOURINARY2'.There are 146548 rows in 6936 pages for object 'LTGENITOURINARY2'.DBCC results for 'LTGAIT'.There are 32826 rows in 1421 pages for object 'LTGAIT'.DBCC results for 'LTHOMEBOUND'.There are 662039 rows in 23306 pages for object 'LTHOMEBOUND'.DBCC results for 'LTINDICAT1'.There are 136650 rows in 7436 pages for object 'LTINDICAT1'.DBCC results for 'LTINDICAT2'.There are 0 rows in 0 pages for object 'LTINDICAT2'.DBCC results for 'am_refin'.There are 7906 rows in 4022 pages for object 'am_refin'.DBCC results for 'LTABDOMEN2'.There are 142456 rows in 2315 pages for object 'LTABDOMEN2'.DBCC results for 'LTINPAT1'.There are 20277 rows in 523 pages for object 'LTINPAT1'.DBCC results for 'LTCLINICAL'.There are 768812 rows in 42963 pages for object 'LTCLINICAL'.DBCC results for 'LTINSURINFO1'.There are 161990 rows in 3222 pages for object 'LTINSURINFO1'.DBCC results for 's_ClinMDWt'.There are 1747 rows in 24 pages for object 's_ClinMDWt'.DBCC results for 'LTEMERGENT'.There are 57938 rows in 3219 pages for object 'LTEMERGENT'.DBCC results for 'LTINTEG1'.There are 109344 rows in 1575 pages for object 'LTINTEG1'.DBCC results for 's_CommNote'.There are 837 rows in 9 pages for object 's_CommNote'.DBCC results for 'LTCARES2'.There are 65512 rows in 3109 pages for object 'LTCARES2'.DBCC results for 'LTINTSTAT1'.There are 0 rows in 0 pages for object 'LTINTSTAT1'.DBCC results for 'LTINTSTAT2'.There are 0 rows in 0 pages for object 'LTINTSTAT2'.DBCC results for 'LTIV'.There are 15440 rows in 3402 pages for object 'LTIV'.DBCC results for 'LTIV1'.There are 0 rows in 0 pages for object 'LTIV1'.DBCC results for 'LTPHYSICIANINFO'.There are 161992 rows in 14813 pages for object 'LTPHYSICIANINFO'.DBCC results for 'LTIV2'.There are 15440 rows in 2445 pages for object 'LTIV2'.DBCC results for 'LTIV3'.There are 15440 rows in 3947 pages for object 'LTIV3'.DBCC results for 'LTREHAB4'.There are 13334 rows in 7157 pages for object 'LTREHAB4'.DBCC results for 'LTLIVING1'.There are 126211 rows in 6021 pages for object 'LTLIVING1'.DBCC results for 'LTLIVING2'.There are 98622 rows in 1316 pages for object 'LTLIVING2'.DBCC results for 'LTSUMMARY'.There are 833743 rows in 77475 pages for object 'LTSUMMARY'.DBCC results for 'LTLIVING3'.There are 98622 rows in 2215 pages for object 'LTLIVING3'.DBCC results for 'LTINSURINFO2'.There are 60657 rows in 12475 pages for object 'LTINSURINFO2'.DBCC results for 'LTLIVING4'.There are 98622 rows in 1629 pages for object 'LTLIVING4'.DBCC results for 'LTLIVING5'.There are 98622 rows in 1543 pages for object 'LTLIVING5'.DBCC results for 'LTREHAB6'.There are 1598 rows in 1594 pages for object 'LTREHAB6'.DBCC results for 'LTLIVING6'.There are 0 rows in 0 pages for object 'LTLIVING6'.DBCC results for 'LTMEDHIST1'.There are 105118 rows in 3275 pages for object 'LTMEDHIST1'.DBCC results for 'LTMEDHIST2'.There are 98622 rows in 3302 pages for object 'LTMEDHIST2'.DBCC results for 'LTENDOCRINE'.There are 722155 rows in 241108 pages for object 'LTENDOCRINE'.DBCC results for 'LTMEDHIST3'.There are 0 rows in 0 pages for object 'LTMEDHIST3'.DBCC results for 'LTMEDHIST4'.There are 109311 rows in 9951 pages for object 'LTMEDHIST4'.DBCC results for 'LTEXPORTS'.There are 7447 rows in 38 pages for object 'LTEXPORTS'.DBCC results for 'LTMEDHIST5'.There are 142470 rows in 1880 pages for object 'LTMEDHIST5'.DBCC results for 'ltmsword'.There are 595 rows in 15 pages for object 'ltmsword'.DBCC results for 'LTMEDICATIONS'.There are 662723 rows in 49866 pages for object 'LTMEDICATIONS'.DBCC results for 'frmreqlink'.There are 34 rows in 1 pages for object 'frmreqlink'.DBCC results for 'LTMEDICATIONS2'.There are 65080 rows in 2441 pages for object 'LTMEDICATIONS2'.DBCC results for 'LTWOUND'.There are 187043 rows in 13961 pages for object 'LTWOUND'.DBCC results for 'ltWoundVAC'.There are 736 rows in 91 pages for object 'ltWoundVAC'.DBCC results for 'LTMEDICATIONS3'.There are 98622 rows in 5294 pages for object 'LTMEDICATIONS3'.DBCC results for 'LTMOUTH'.There are 666778 rows in 27518 pages for object 'LTMOUTH'.DBCC results for 'LTNEURO1'.There are 0 rows in 0 pages for object 'LTNEURO1'.DBCC results for 'LTTHERO5'.There are 91909 rows in 2431 pages for object 'LTTHERO5'.DBCC results for 'LTNOSE'.There are 666783 rows in 20548 pages for object 'LTNOSE'.DBCC results for 'LTNTM'.There are 0 rows in 0 pages for object 'LTNTM'.DBCC results for 'LTMISSED'.There are 95778 rows in 3567 pages for object 'LTMISSED'.DBCC results for 'LTNUTRITION'.There are 0 rows in 0 pages for object 'LTNUTRITION'.DBCC results for 'LTPAIN1'.There are 142472 rows in 6586 pages for object 'LTPAIN1'.DBCC results for 'LTPAIN2'.There are 1102191 rows in 227112 pages for object 'LTPAIN2'.DBCC results for 'LTPAIN3'.There are 0 rows in 0 pages for object 'LTPAIN3'.DBCC results for 'LTREHAB2'.There are 39182 rows in 6406 pages for object 'LTREHAB2'.DBCC results for 'LTPATETHN'.There are 0 rows in 0 pages for object 'LTPATETHN'.DBCC results for 'LTPATINFO2'.There are 60672 rows in 796 pages for object 'LTPATINFO2'.DBCC results for 'LTPATTRK'.There are 0 rows in 0 pages for object 'LTPATTRK'.DBCC results for 'LTPCLINT'.There are 2750 rows in 1444 pages for object 'LTPCLINT'.DBCC results for 'ltmedtrack2'.There are 108986 rows in 59969 pages for object 'ltmedtrack2'.DBCC results for 'ltmedtrack'.There are 108973 rows in 108973 pages for object 'ltmedtrack'.DBCC results for 'LTPHYSICIANO1'.There are 0 rows in 0 pages for object 'LTPHYSICIANO1'.DBCC results for 'LTMENTAL'.There are 146548 rows in 3462 pages for object 'LTMENTAL'.DBCC results for 'LTPHYSICIANO2'.There are 0 rows in 0 pages for object 'LTPHYSICIANO2'.DBCC results for 'LTPROG1'.There are 60672 rows in 762 pages for object 'LTPROG1'.DBCC results for 'LTPROG2'.There are 98624 rows in 1272 pages for object 'LTPROG2'.DBCC results for 'LTPROG3'.There are 105118 rows in 1371 pages for object 'LTPROG3'.DBCC results for 'LTGENITOURINARY'.There are 596659 rows in 95942 pages for object 'LTGENITOURINARY'.DBCC results for 'LTPROG4'.There are 60672 rows in 1031 pages for object 'LTPROG4'.DBCC results for 'LTPSYCHOSOCIAL'.There are 739581 rows in 56309 pages for object 'LTPSYCHOSOCIAL'.DBCC results for 'LTVISITS'.There are 1303974 rows in 231313 pages for object 'LTVISITS'.DBCC results for 'LTREHAB1'.There are 39182 rows in 5254 pages for object 'LTREHAB1'.DBCC results for 'LTREHAB3'.There are 13334 rows in 3290 pages for object 'LTREHAB3'.DBCC results for 'LTREHAB5'.There are 39179 rows in 1878 pages for object 'LTREHAB5'.DBCC results for 'LTMEDHIST6'.There are 109374 rows in 13788 pages for object 'LTMEDHIST6'.DBCC results for 'LTPATINFO1'.There are 161992 rows in 10984 pages for object 'LTPATINFO1'.DBCC results for 'LTSUP1'.There are 50953 rows in 4174 pages for object 'LTSUP1'.DBCC results for 'LTREHAB7'.There are 0 rows in 0 pages for object 'LTREHAB7'.CHECKDB found 0 allocation errors and 0 consistency errors in database 'POCTest'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.ThomBeaux |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-05-22 : 14:46:26
|
| You've got issues with your IO subsystem hardware. An 823 error means that something is preventing the physical read from completing. This also explains thet seemingly random corruptions you've been seeing.Things to do:1) run IO subsystem diagnostics2) check all your firmware/drivers are up-to-date3) download and run the SQLIOSim tool (google it to get the link - don't have it handy)Depending on your SLAs, you may need to move to a different IO subsystem until this is sorted out.ThanksPaul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
thombeaux
Starting Member
18 Posts |
Posted - 2007-05-23 : 09:16:18
|
| We rebuilt the OS and SQL Server on the machine, no problem with hardware, and one database came up without any errors.Now, we are restoring a second database (190 gigs) and the restore has been running for 4 hours. This restore usually take 2 hours on another server that we do once a month.I am noticing with sp_who3, that the spid for the restore is listing on only 2 'theads' on this server, when it shows 9-13 "threads" on the once a month restore server.Could there be a configuration setting in Window 2003 Server or SQL Server that we forgot.HP Integrity rx4640Quad Itanium 1.10GHz Processors64GB RAMWindows Server 2003, Enterprise Edition for 64-Bit Itanium-based Systemsthanks,ThombeauxThomBeaux |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-05-23 : 10:39:39
|
| Did you do all the IO subsystem testing I described? The 823 error is an IO problem - not OS, so rebuilding the OS and SQL Server shouldn't have any effect on it.Let me check on the restore issue.Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-05-23 : 13:29:02
|
| (Thanks to Kevin Farlee on my team)We use one thread for each unique Windows volume on the source and one thread for each unique volume on the destination.So, for example, if the original database was spread across 8 volumes, with the backup on another 4 volumes, and the restore database was all put on one gigantic volume, this result would be expected.Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
thombeaux
Starting Member
18 Posts |
Posted - 2007-05-23 : 15:01:09
|
| The slowness of the restore was caused by the SAN being mirrored to an off-site storage SAN. Once the mirror was broken, everything came out OK.1) run IO subsystem diagnosticsOK2) check all your firmware/drivers are up-to-dateUp to date3) - No timeWe spent the whole evening and morning getting the databases back up and running.The multiple rows of same SPID in sp_who3 'Active' came up once the SAN mirror was broken. Apparently, it was trying to mirror the whole 190+ gig data file at once.Thanks and God Bless,ThomBeauxThomBeaux |
|
|
|
|
|
|
|
|
Data Inconsistency...