InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 17:28:23 GMT20http://www.sqlservercentral.com/Forums/Topic1116704-2893-1.aspxHi All,I have a problem in SQL Server 2008 R2.I was running a query that updated huge data in database, therefore it takes a lot of time to finish.And before the query has been finished (after 1 hour processing), I got error message "Cannot open database "XXX" requested by the login. The login failed". And then I tried to connect to that database again, and the Database became XXX(In Recovery). After 5 hours, the database has recovered on its own.Does anybody know what is the problem that might cause this issues(database became In Recovery)?Thanks in advanceSat, 28 May 2011 19:56:25 GMTratna_ainhttp://www.sqlservercentral.com/Forums/Topic1462705-2893-1.aspxHi,We've been having sporadic cases of corruption. The tables vary but the message is consistent:[font="Courier New"]Msg 605, Level 21, State 3, Line 1Attempt to fetch logical page (5:537) in database 47 failed. It belongs to allocation unit 72057602025521152 not to 72057602063532032.[/font]When I inspect the tables using DBCC IND and DBCC PAGE I can see that, for example, page 5:537 does have an incorrect allocation unit in it's header (as compared to the IAM page).Yes, most sources state that most corruption is caused by I/O sub-system, but in our situation we need to prove this.On this ms page [url]http://support.microsoft.com/kb/2015739[/url] it reads:[quote]Ensure you have the PAGE_VERIFY=CHECKSUM database option turned on. While it is possible to still encounter a Msg 605 error with checksum enabled (Ex. "scribbler" problem or incorrect page provided from I/O system), enabling checksum can provide definitive proof that the page was modified incorrectly within the I/O system.[/quote]Could anyone explain to me how this provides definitive proof? Definitive proof would be very helpful in our case!ThanksWed, 12 Jun 2013 09:45:37 GMTDCFhttp://www.sqlservercentral.com/Forums/Topic1344952-2893-1.aspxHi All, What is this error ? any idea why do we see such kind of errors?LogWriter: Operating system error 170(The requested resource is in use.) encountered.Error: 17053, Severity: 16, State: 1.LogWriter: Operating system error 170(The requested resource is in use.) encountered.Write error during log flush.Error: 9001, Severity: 21, State: 4.The log for database 'msdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database.Database msdb was shutdown due to error 9001 in routine 'XdesRMFull::Commit'. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.Thanks in Advance.Tue, 14 Aug 2012 12:23:57 GMTOracle_91http://www.sqlservercentral.com/Forums/Topic1239942-2893-1.aspxHi, we've recently encountered a corruption situation and I'm testing the latest backup to make sure it is okay. Based on the output, I think we can just restore table 'xxx' (by restoring the database on another server and they copying the table over) since most of the errors refer to it, but I'm not positive if that would fix the two consistency errors mentioned. Below is the DBCC output. Any help would be greatly appreciated!Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (27:59906942) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (27:59906943) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).CHECKDB found 0 allocation errors and 2 consistency errors not associated with any single object.Msg 8928, Level 16, State 1, Line 1Object ID 754101727, index ID 1, partition ID 72057594043170816, alloc unit ID 72057594047365120 (type In-row data): Page (27:59906941) could not be processed. See other errors for details.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 754101727, index ID 1, partition ID 72057594043170816, alloc unit ID 72057594047365120 (type In-row data), page (27:59906941). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 754101727, index ID 1, partition ID 72057594043170816, alloc unit ID 72057594047365120 (type In-row data). Page (27:59906941) was not seen in the scan although its parent (27:59907053) and previous (27:59906940) refer to it. Check any previous errors.Msg 8928, Level 16, State 1, Line 1Object ID 754101727, index ID 1, partition ID 72057594043170816, alloc unit ID 72057594047365120 (type In-row data): Page (27:59906942) could not be processed. See other errors for details.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 754101727, index ID 1, partition ID 72057594043170816, alloc unit ID 72057594047365120 (type In-row data). Index node page (27:59907053), slot 152 refers to child page (27:59906942) and previous child (27:59906941), but they were not encountered.Msg 8928, Level 16, State 1, Line 1Object ID 754101727, index ID 1, partition ID 72057594043170816, alloc unit ID 72057594047365120 (type In-row data): Page (27:59906943) could not be processed. See other errors for details.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 754101727, index ID 1, partition ID 72057594043170816, alloc unit ID 72057594047365120 (type In-row data). Index node page (27:59907053), slot 153 refers to child page (27:59906943) and previous child (27:59906942), but they were not encountered.Msg 8978, Level 16, State 1, Line 1Table error: Object ID 754101727, index ID 1, partition ID 72057594043170816, alloc unit ID 72057594047365120 (type In-row data). Page (27:59906944) is missing a reference from previous page (27:59906943). Possible chain linkage problem.CHECKDB found 0 allocation errors and 8 consistency errors in table 'xxx' (object ID 754101727).CHECKDB found 0 allocation errors and 10 consistency errors in database 'yyy'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (yyy)Sun, 22 Jan 2012 12:10:30 GMTGary Hineshttp://www.sqlservercentral.com/Forums/Topic1448442-2893-1.aspxHiWe have a SQL 2008 database with a torn page.The table with the issue contains data which we don't really care about.We do have good backups however, restoring will be a pain as results in a prolonged outage due to size of db. It has been suggested that we can truncate the table, however, I googled and someone had a problem with this in sql2k.Like I say, we don't care about the data but we would like to stop the errors occuring continuously in our errorlog. Does anyone know whether a truncate will work in SQL2008?Wed, 01 May 2013 08:37:19 GMTkirkysqlhttp://www.sqlservercentral.com/Forums/Topic1197653-2893-1.aspxI'm not sure if the database is corrupted but am having issues getting a backups to work. Error: The driver detected a controller error on \device\harddisk0\DR0.In SQL log: The operating system returned error 1117(the request could not be performed because of an i/o device error) to SQL Server during a read at offset 0x....And: Read on 'D:\...mdf' failed 1117(the request could not be performed because of an i/o device error)Our server administrator found an error with the drive and swapped it out. I'm still haveing i/o errors for two of the databases though. Are they corrupt? How can I tell if they should be restored? I there a setting somewhere that would have to be set after the drive swap?I ran dbcc checkdb on the 2 databases and they also have a 1117 error.Any help or advice on this? Thanks very much.Fri, 28 Oct 2011 13:41:52 GMTDenise McMillanhttp://www.sqlservercentral.com/Forums/Topic1439738-2893-1.aspxI am developer and new to SQL Server. We are using SQL Server 2008 R2 and recently i am getting following errors.SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x00000000; actual signature: 0x38203d60). It occurred during a read of page (1:2240128) in database ID 7 at offset 0x00000445d00000 in file 'D:\LiveWebsite\SQLDB\VF.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.I have got the backup of DB but not a clean one prior to getting this errors. I read on internet and ran DBCC checkdb. Here are the results of running DBCC CHCKDB before repair_allow_data_loss before & after dbcc CHECKDB. I also ran Disk Usage by Top Tables before & after repair_allow_data_loss and compared the row count for each table and they were exactly the same for each table.Does that mean there was no data loss in any of the table? From the logs can anyone that corruption in any table is fixed now?--------------------------------------------------------------------------------------------------[b]DBCC CHCKDB before repair_allow_data_loss[/b]--------------------------------------------------------------------------------------------------Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8412160578939125760 (type Unknown), page (1:2240096). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8431627719984480256 (type Unknown), page (2562:303566172). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2153232668127264768 (type Unknown), page (65522:2030439032). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7132289577369796608 (type Unknown), page (41951:1887729385). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7797623440568614912 (type Unknown), page (24913:1105251738). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8055213396263108608 (type Unknown), page (7956:-1908257711). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 1657509454024933376 (type Unknown), page (8796:-1120047100). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2692432819999473664 (type Unknown), page (17587:-2066993626). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8626575908248813568 (type Unknown), page (1:2240104). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -9005183832006918144 (type Unknown), page (46704:-1054509774). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1504451185603510272 (type Unknown), page ID (1:2240106) contains an incorrect page ID in its page header. The PageId in the page header = (39944:118969040).Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 3146556001005076480 (type Unknown), page (26183:-1290038611). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7258917288141062144 (type Unknown), page (2550:238301252). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4287411102228938752 (type Unknown), page (44261:-605678773). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4329211631246966784 (type Unknown), page (36846:-804604142). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -572619962521616384 (type Unknown), page (56373:782066909). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 622906258979815424 (type Unknown), page (1:2240112). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8661671964451995648 (type Unknown), page (49969:1298094176). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -7475287558769737728 (type Unknown), page (5912:1114982481). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8618317043423969280 (type Unknown), page (26295:-409711573). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4347896695996874752 (type Unknown), page (2372:-2029657033). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9034919118390755328 (type Unknown), page (4096:248204469). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -2085671439325986816 (type Unknown), page ID (1:2240118) contains an incorrect page ID in its page header. The PageId in the page header = (17100:1674060134).Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8541786794736680960 (type Unknown), page (1416:1700938541). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -4559282601775464448 (type Unknown), page (1:2240120). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1899679717971263488 (type Unknown), page ID (1:2240121) contains an incorrect page ID in its page header. The PageId in the page header = (38320:-1059637258).Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 71956802146336768 (type Unknown), page ID (1:2240122) contains an incorrect page ID in its page header. The PageId in the page header = (8360:185660294).Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -9114801744139583488 (type Unknown), page (59965:-676250289). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -4728665513999728640 (type Unknown), page (27730:415707761). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4611936706646573056 (type Unknown), page (1:2240128). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 20628232407220224 (type Unknown), page (25651:-241315940). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7106680404197441536 (type Unknown), page (1603:100749868). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.CHECKDB found 0 allocation errors and 32 consistency errors not associated with any single object.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240096) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240097) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240098) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240099) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240100) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240101) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240102) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240103) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240104) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240105) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240106) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240107) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240108) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240109) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240110) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240111) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240112) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240113) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240114) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240115) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240116) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240117) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240118) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240119) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240120) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240121) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240122) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240123) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240124) could not be processed. See other errors for details.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Page (1:2240096) was not seen in the scan although its parent (1:1356704) and previous (1:1526789) refer to it. Check any previous errors.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 8 refers to child page (1:2240097) and previous child (1:2240096), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 9 refers to child page (1:2240098) and previous child (1:2240097), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 10 refers to child page (1:2240099) and previous child (1:2240098), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 11 refers to child page (1:2240100) and previous child (1:2240099), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 12 refers to child page (1:2240101) and previous child (1:2240100), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 13 refers to child page (1:2240102) and previous child (1:2240101), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 14 refers to child page (1:2240103) and previous child (1:2240102), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 15 refers to child page (1:2240104) and previous child (1:2240103), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 16 refers to child page (1:2240105) and previous child (1:2240104), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 17 refers to child page (1:2240106) and previous child (1:2240105), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 18 refers to child page (1:2240107) and previous child (1:2240106), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 19 refers to child page (1:2240108) and previous child (1:2240107), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 20 refers to child page (1:2240109) and previous child (1:2240108), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 21 refers to child page (1:2240110) and previous child (1:2240109), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 22 refers to child page (1:2240111) and previous child (1:2240110), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 23 refers to child page (1:2240112) and previous child (1:2240111), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 24 refers to child page (1:2240113) and previous child (1:2240112), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 25 refers to child page (1:2240114) and previous child (1:2240113), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 26 refers to child page (1:2240115) and previous child (1:2240114), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 27 refers to child page (1:2240116) and previous child (1:2240115), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 28 refers to child page (1:2240117) and previous child (1:2240116), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 29 refers to child page (1:2240118) and previous child (1:2240117), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 30 refers to child page (1:2240119) and previous child (1:2240118), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 31 refers to child page (1:2240120) and previous child (1:2240119), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 32 refers to child page (1:2240121) and previous child (1:2240120), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 33 refers to child page (1:2240122) and previous child (1:2240121), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 34 refers to child page (1:2240123) and previous child (1:2240122), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 35 refers to child page (1:2240124) and previous child (1:2240123), but they were not encountered.CHECKDB found 0 allocation errors and 58 consistency errors in table 'sys.ifts_comp_fragment_1630628852_195760' (object ID 1709768623).Msg 8928, Level 16, State 2, Line 1Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240128) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240129) could not be processed. See other errors for details.Msg 8928, Level 16, State 2, Line 1Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240130) could not be processed. See other errors for details.Msg 8976, Level 16, State 1, Line 1Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Page (1:2240128) was not seen in the scan although its parent (1:1714459) and previous (1:1821640) refer to it. Check any previous errors.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Index node page (1:1714459), slot 8 refers to child page (1:2240129) and previous child (1:2240128), but they were not encountered.Msg 8980, Level 16, State 1, Line 1Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Index node page (1:1714459), slot 9 refers to child page (1:2240130) and previous child (1:2240129), but they were not encountered.CHECKDB found 0 allocation errors and 6 consistency errors in table 'sys.ifts_comp_fragment_1630628852_195761' (object ID 1725768680).CHECKDB found 0 allocation errors and 96 consistency errors in database 'VF'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (VF).---------------------------------------------------------------------------------------------------[b]DBCC CHCKDB repair_allow_data_loss[/b] --------------------------------------------------------------------------------------------------DBCC results for 'VF'.Service Broker Msg 9675, State 1: Message Types analyzed: 14.Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.Service Broker Msg 9667, State 1: Services analyzed: 3.Service Broker Msg 9668, State 1: Service Queues analyzed: 3.Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -9114801744139583488 (type Unknown), page (59965:-676250289). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -9005183832006918144 (type Unknown), page (46704:-1054509774). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8661671964451995648 (type Unknown), page (49969:1298094176). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8626575908248813568 (type Unknown), page (1:2240104). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4. The error has been repaired.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8618317043423969280 (type Unknown), page (26295:-409711573). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8412160578939125760 (type Unknown), page (1:2240096). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. The error has been repaired.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8055213396263108608 (type Unknown), page (7956:-1908257711). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -7475287558769737728 (type Unknown), page (5912:1114982481). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -4728665513999728640 (type Unknown), page (27730:415707761). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -4559282601775464448 (type Unknown), page (1:2240120). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4. The error has been repaired.Msg 8909, Level 16, State 1, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -2085671439325986816 (type Unknown), page ID (1:2240118) contains an incorrect page ID in its page header. The PageId in the page header = (17100:1674060134). The error has been repaired.Msg 8909, Level 16, State 1, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1899679717971263488 (type Unknown), page ID (1:2240121) contains an incorrect page ID in its page header. The PageId in the page header = (38320:-1059637258). The error has been repaired.Msg 8909, Level 16, State 1, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1504451185603510272 (type Unknown), page ID (1:2240106) contains an incorrect page ID in its page header. The PageId in the page header = (39944:118969040). The error has been repaired.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -572619962521616384 (type Unknown), page (56373:782066909). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 20628232407220224 (type Unknown), page (25651:-241315940). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4. Could not repair this error.Msg 8909, Level 16, State 1, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 71956802146336768 (type Unknown), page ID (1:2240122) contains an incorrect page ID in its page header. The PageId in the page header = (8360:185660294). The error has been repaired.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 622906258979815424 (type Unknown), page (1:2240112). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. The error has been repaired.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 1657509454024933376 (type Unknown), page (8796:-1120047100). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2153232668127264768 (type Unknown), page (65522:2030439032). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2692432819999473664 (type Unknown), page (17587:-2066993626). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 3146556001005076480 (type Unknown), page (26183:-1290038611). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4287411102228938752 (type Unknown), page (44261:-605678773). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4329211631246966784 (type Unknown), page (36846:-804604142). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4347896695996874752 (type Unknown), page (2372:-2029657033). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4611936706646573056 (type Unknown), page (1:2240128). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. The error has been repaired.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7106680404197441536 (type Unknown), page (1603:100749868). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7132289577369796608 (type Unknown), page (41951:1887729385). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7258917288141062144 (type Unknown), page (2550:238301252). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -1. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 7797623440568614912 (type Unknown), page (24913:1105251738). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -10. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8431627719984480256 (type Unknown), page (2562:303566172). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 8541786794736680960 (type Unknown), page (1416:1700938541). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4. Could not repair this error.Msg 8939, Level 16, State 98, Line 6Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9034919118390755328 (type Unknown), page (4096:248204469). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -14. Could not repair this error.CHECKDB found 0 allocation errors and 32 consistency errors not associated with any single object.CHECKDB fixed 0 allocation errors and 9 consistency errors not associated with any single object.DBCC results for 'sys.sysrscols'.There are 6199 rows in 151 pages for object "sys.sysrscols".DBCC results for 'sys.sysrowsets'.There are 689 rows in 10 pages for object "sys.sysrowsets".DBCC results for 'sys.sysclones'.There are 0 rows in 0 pages for object "sys.sysclones".DBCC results for 'sys.sysallocunits'.There are 754 rows in 13 pages for object "sys.sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.sysseobjvalues'.There are 0 rows in 0 pages for object "sys.sysseobjvalues".DBCC results for 'sys.syspriorities'.There are 0 rows in 0 pages for object "sys.syspriorities".DBCC results for 'sys.sysdbfrag'.There are 0 rows in 0 pages for object "sys.sysdbfrag".DBCC results for 'sys.sysfgfrag'.There are 0 rows in 1 pages for object "sys.sysfgfrag".DBCC results for 'sys.sysdbfiles'.There are 2 rows in 1 pages for object "sys.sysdbfiles".DBCC results for 'sys.syspru'.There are 0 rows in 0 pages for object "sys.syspru".DBCC results for 'sys.sysbrickfiles'.There are 0 rows in 0 pages for object "sys.sysbrickfiles".DBCC results for 'sys.sysphfg'.There are 1 rows in 1 pages for object "sys.sysphfg".DBCC results for 'sys.sysprufiles'.There are 2 rows in 1 pages for object "sys.sysprufiles".DBCC results for 'sys.sysftinds'.There are 1 rows in 1 pages for object "sys.sysftinds".DBCC results for 'sys.sysowners'.There are 17 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysdbreg'.There are 0 rows in 0 pages for object "sys.sysdbreg".DBCC results for 'sys.sysprivs'.There are 155 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.There are 3413 rows in 54 pages for object "sys.sysschobjs".DBCC results for 'sys.syscolpars'.There are 7223 rows in 148 pages for object "sys.syscolpars".DBCC results for 'sys.sysxlgns'.There are 0 rows in 0 pages for object "sys.sysxlgns".DBCC results for 'sys.sysxsrvs'.There are 0 rows in 0 pages for object "sys.sysxsrvs".DBCC results for 'sys.sysnsobjs'.There are 1 rows in 1 pages for object "sys.sysnsobjs".DBCC results for 'sys.sysusermsgs'.There are 0 rows in 0 pages for object "sys.sysusermsgs".DBCC results for 'sys.syscerts'.There are 0 rows in 0 pages for object "sys.syscerts".DBCC results for 'sys.sysrmtlgns'.There are 0 rows in 0 pages for object "sys.sysrmtlgns".DBCC results for 'sys.syslnklgns'.There are 0 rows in 0 pages for object "sys.syslnklgns".DBCC results for 'sys.sysxprops'.There are 20 rows in 1 pages for object "sys.sysxprops".DBCC results for 'sys.sysscalartypes'.There are 34 rows in 1 pages for object "sys.sysscalartypes".DBCC results for 'sys.systypedsubobjs'.There are 0 rows in 0 pages for object "sys.systypedsubobjs".DBCC results for 'sys.sysidxstats'.There are 1519 rows in 36 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 3365 rows in 30 pages for object "sys.sysiscols".DBCC results for 'sys.sysendpts'.There are 0 rows in 0 pages for object "sys.sysendpts".DBCC results for 'sys.syswebmethods'.There are 0 rows in 0 pages for object "sys.syswebmethods".DBCC results for 'sys.sysbinobjs'.There are 23 rows in 1 pages for object "sys.sysbinobjs".DBCC results for 'sys.sysaudacts'.There are 0 rows in 0 pages for object "sys.sysaudacts".DBCC results for 'sys.sysobjvalues'.There are 2088 rows in 606 pages for object "sys.sysobjvalues".DBCC results for 'sys.syscscolsegments'.There are 0 rows in 0 pages for object "sys.syscscolsegments".DBCC results for 'sys.syscsdictionaries'.There are 0 rows in 0 pages for object "sys.syscsdictionaries".DBCC results for 'sys.sysclsobjs'.There are 17 rows in 1 pages for object "sys.sysclsobjs".DBCC results for 'sys.sysrowsetrefs'.There are 0 rows in 0 pages for object "sys.sysrowsetrefs".DBCC results for 'sys.sysremsvcbinds'.There are 0 rows in 0 pages for object "sys.sysremsvcbinds".DBCC results for 'sys.sysxmitqueue'.There are 0 rows in 0 pages for object "sys.sysxmitqueue".DBCC results for 'sys.sysrts'.There are 1 rows in 1 pages for object "sys.sysrts".DBCC results for 'sys.sysconvgroup'.There are 0 rows in 0 pages for object "sys.sysconvgroup".DBCC results for 'sys.sysdesend'.There are 0 rows in 0 pages for object "sys.sysdesend".DBCC results for 'sys.sysdercv'.There are 0 rows in 0 pages for object "sys.sysdercv".DBCC results for 'sys.syssingleobjrefs'.There are 796 rows in 5 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 3893 rows in 28 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysguidrefs'.There are 0 rows in 0 pages for object "sys.sysguidrefs".DBCC results for 'sys.sysfoqueues'.There are 0 rows in 0 pages for object "sys.sysfoqueues".DBCC results for 'sys.syschildinsts'.There are 0 rows in 0 pages for object "sys.syschildinsts".DBCC results for 'sys.syscompfragments'.There are 410 rows in 5 pages for object "sys.syscompfragments".DBCC results for 'sys.sysftsemanticsdb'.There are 0 rows in 0 pages for object "sys.sysftsemanticsdb".DBCC results for 'sys.sysftstops'.There are 0 rows in 0 pages for object "sys.sysftstops".DBCC results for 'sys.sysftproperties'.There are 0 rows in 0 pages for object "sys.sysftproperties".DBCC results for 'sys.sysxmitbody'.There are 0 rows in 0 pages for object "sys.sysxmitbody".DBCC results for 'sys.sysfos'.There are 0 rows in 0 pages for object "sys.sysfos".DBCC results for 'sys.sysqnames'.There are 98 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 100 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 112 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 19 rows in 1 pages for object "sys.sysxmlplacement".DBCC results for 'sys.sysobjkeycrypts'.There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".DBCC results for 'sys.sysasymkeys'.There are 0 rows in 0 pages for object "sys.sysasymkeys".DBCC results for 'sys.syssqlguides'.There are 0 rows in 0 pages for object "sys.syssqlguides".DBCC results for 'sys.sysbinsubobjs'.There are 3 rows in 1 pages for object "sys.sysbinsubobjs".DBCC results for 'sys.syssoftobjrefs'.There are 969 rows in 11 pages for object "sys.syssoftobjrefs".DBCC results for 'sys.ifts_comp_fragment_1630628852_197936'.There are 1796 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197936".DBCC results for 'sys.ifts_comp_fragment_1630628852_196594'.There are 2482 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_196594".DBCC results for 'sys.ifts_comp_fragment_1630628852_195923'.There are 1824 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195923".DBCC results for 'sys.ifts_comp_fragment_1630628852_195789'.There are 1812 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195789".DBCC results for 'Association'.There are 15491 rows in 324 pages for object "Association".DBCC results for 'sys.filestream_tombstone_14623095'.There are 0 rows in 0 pages for object "sys.filestream_tombstone_14623095".DBCC results for 'Company'.There are 131476 rows in 6564 pages for object "Company".DBCC results for 'sys.ifts_comp_fragment_1630628852_198071'.There are 3293 rows in 22 pages for object "sys.ifts_comp_fragment_1630628852_198071".DBCC results for 'sys.syscommittab'.There are 0 rows in 0 pages for object "sys.syscommittab".DBCC results for 'sys.ifts_comp_fragment_1630628852_197401'.There are 1727 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197401".DBCC results for 'sys.ifts_comp_fragment_1630628852_197938'.There are 2009 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197938".DBCC results for 'sys.ifts_comp_fragment_1630628852_196596'.There are 2882 rows in 19 pages for object "sys.ifts_comp_fragment_1630628852_196596".DBCC results for 'sys.ifts_comp_fragment_1630628852_195925'.There are 1982 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_195925".DBCC results for 'sys.ifts_comp_fragment_1630628852_197133'.There are 1790 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197133".DBCC results for 'ContactMethod'.There are 318354 rows in 2704 pages for object "ContactMethod".DBCC results for 'ContactRanks'.There are 585 rows in 3 pages for object "ContactRanks".DBCC results for 'CandidatesMaster'.There are 1023 rows in 36 pages for object "CandidatesMaster".DBCC results for 'sys.ifts_comp_fragment_1630628852_196463'.There are 1817 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196463".DBCC results for 'sys.ifts_comp_fragment_1630628852_198208'.There are 1841 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_198208".DBCC results for 'sys.ifts_comp_fragment_1630628852_197940'.There are 2331 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197940".DBCC results for 'sys.ifts_comp_fragment_1630628852_197269'.There are 1933 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197269".DBCC results for 'sys.ifts_comp_fragment_1630628852_197135'.There are 1794 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197135".DBCC results for 'sys.ifts_comp_fragment_1630628852_196733'.There are 2271 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_196733".DBCC results for 'sys.ifts_comp_fragment_1630628852_196465'.There are 1747 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196465".DBCC results for 'sys.ifts_comp_fragment_1630628852_197942'.There are 2073 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197942".DBCC results for 'sys.ifts_comp_fragment_1630628852_197271'.There are 2581 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_197271".DBCC results for 'sys.ifts_comp_fragment_1630628852_197674'.There are 1956 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197674".DBCC results for 'sys.ifts_comp_fragment_1630628852_195795'.There are 1868 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_195795".DBCC results for 'sys.ifts_comp_fragment_1630628852_196332'.There are 2921 rows in 19 pages for object "sys.ifts_comp_fragment_1630628852_196332".DBCC results for 'sys.ifts_comp_fragment_1630628852_197406'.There are 2170 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197406".DBCC results for 'sys.ifts_comp_fragment_1630628852_196735'.There are 1847 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196735".DBCC results for 'Captcha'.There are 15 rows in 1 pages for object "Captcha".DBCC results for 'sys.ifts_comp_fragment_1630628852_197809'.There are 1590 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197809".DBCC results for 'sys.ifts_comp_fragment_1630628852_197138'.There are 1903 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197138".DBCC results for 'sys.ifts_comp_fragment_1630628852_196467'.There are 1752 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196467".DBCC results for 'CandidatesEmployment'.There are 2371 rows in 151 pages for object "CandidatesEmployment".DBCC results for 'sys.ifts_comp_fragment_1630628852_197944'.There are 1714 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197944".DBCC results for 'Notes'.There are 100835 rows in 617 pages for object "Notes".DBCC results for 'JobTypeTime'.There are 2 rows in 1 pages for object "JobTypeTime".DBCC results for 'sys.ifts_comp_fragment_1630628852_198079'.There are 1980 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_198079".DBCC results for 'sys.ifts_comp_fragment_1630628852_125285'.There are 749265 rows in 26011 pages for object "sys.ifts_comp_fragment_1630628852_125285".DBCC results for 'sys.ifts_comp_fragment_1630628852_196335'.There are 1775 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196335".DBCC results for 'sys.ifts_comp_fragment_1630628852_196201'.There are 2647 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_196201".DBCC results for 'sys.ifts_comp_fragment_1630628852_196738'.There are 1770 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196738".DBCC results for 'sys.ifts_comp_fragment_1630628852_197946'.There are 2269 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197946".DBCC results for 'sys.ifts_comp_fragment_1630628852_196067'.There are 1594 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196067".DBCC results for 'sys.ifts_comp_fragment_1630628852_195799'.There are 1890 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195799".DBCC results for 'CandidatesEducation'.There are 2664 rows in 77 pages for object "CandidatesEducation".DBCC results for 'sys.ifts_comp_fragment_1630628852_197276'.There are 15549 rows in 126 pages for object "sys.ifts_comp_fragment_1630628852_197276".DBCC results for 'sys.ifts_comp_fragment_1630628852_196471'.There are 2140 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196471".DBCC results for 'Department'.There are 3 rows in 1 pages for object "Department".DBCC results for 'sys.ifts_comp_fragment_1630628852_196337'.There are 1721 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196337".DBCC results for 'sys.ifts_comp_fragment_1630628852_196203'.There are 1585 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196203".DBCC results for 'sys.ifts_comp_fragment_1630628852_197411'.There are 14069 rows in 111 pages for object "sys.ifts_comp_fragment_1630628852_197411".DBCC results for 'Sequence'.There are 2 rows in 1 pages for object "Sequence".DBCC results for 'sys.ifts_comp_fragment_1630628852_197949'.There are 15888 rows in 139 pages for object "sys.ifts_comp_fragment_1630628852_197949".DBCC results for 'sys.ifts_comp_fragment_1630628852_197815'.There are 1989 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197815".DBCC results for 'CandidatesApplications'.There are 913 rows in 10 pages for object "CandidatesApplications".DBCC results for 'ActionType'.There are 20 rows in 1 pages for object "ActionType".DBCC results for 'sys.ifts_comp_fragment_1630628852_197011'.There are 1872 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197011".DBCC results for 'AdvertPostingTable'.There are 0 rows in 0 pages for object "AdvertPostingTable".DBCC results for 'sys.ifts_comp_fragment_1630628852_197951'.There are 1851 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197951".DBCC results for 'sys.ifts_comp_fragment_1630628852_196609'.There are 1866 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196609".DBCC results for 'sys.ifts_comp_fragment_1630628852_196475'.There are 3600 rows in 24 pages for object "sys.ifts_comp_fragment_1630628852_196475".DBCC results for 'sys.ifts_comp_fragment_1630628852_197683'.There are 2183 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197683".DBCC results for 'sys.ifts_comp_fragment_1630628852_197549'.There are 1610 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197549".DBCC results for 'sys.ifts_comp_fragment_1630628852_197415'.There are 1811 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197415".DBCC results for 'ResponseQuality'.There are 14 rows in 1 pages for object "ResponseQuality".DBCC results for 'sys.ifts_comp_fragment_1630628852_197013'.There are 1976 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197013".DBCC results for 'sys.ifts_comp_fragment_1630628852_198087'.There are 1720 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198087".DBCC results for 'ApplicantAttachments'.There are 0 rows in 0 pages for object "ApplicantAttachments".DBCC results for 'sys.ifts_comp_fragment_1630628852_197953'.There are 2364 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197953".DBCC results for 'Users'.There are 45 rows in 1 pages for object "Users".DBCC results for 'sys.ifts_comp_fragment_1630628852_197551'.There are 2238 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197551".DBCC results for 'CandidatesProfiles'.There are 987 rows in 44 pages for object "CandidatesProfiles".DBCC results for 'ApplicantSource'.There are 0 rows in 0 pages for object "ApplicantSource".DBCC results for 'sys.ifts_comp_fragment_1630628852_197417'.There are 2647 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_197417".DBCC results for 'CompanyLocations'.There are 46 rows in 1 pages for object "CompanyLocations".DBCC results for 'ApplicationSectionControl'.There are 0 rows in 0 pages for object "ApplicationSectionControl".DBCC results for 'sys.ifts_comp_fragment_1630628852_196478'.There are 17816 rows in 152 pages for object "sys.ifts_comp_fragment_1630628852_196478".DBCC results for 'sys.ifts_comp_fragment_1630628852_195807'.There are 2084 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_195807".DBCC results for 'sys.ifts_comp_fragment_1630628852_197015'.There are 1998 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197015".DBCC results for 'sys.ifts_comp_fragment_1630628852_198223'.There are 1779 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_198223".DBCC results for 'Contacts'.There are 188563 rows in 5326 pages for object "Contacts".DBCC results for 'InvoiceStatus'.There are 0 rows in 0 pages for object "InvoiceStatus".DBCC results for 'sys.ifts_comp_fragment_1630628852_196613'.There are 1795 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196613".DBCC results for 'sys.ifts_comp_fragment_1630628852_197821'.There are 2419 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197821".DBCC results for 'PaymentStatus'.There are 0 rows in 0 pages for object "PaymentStatus".DBCC results for 'DocumentBase'.There are 1 rows in 1 pages for object "DocumentBase".DBCC results for 'ApplicationSections'.There are 5 rows in 1 pages for object "ApplicationSections".DBCC results for 'sys.ifts_comp_fragment_1630628852_195809'.There are 2019 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_195809".DBCC results for 'sys.ifts_comp_fragment_1630628852_197017'.There are 2721 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_197017".DBCC results for 'CandidatesReferences'.There are 988 rows in 28 pages for object "CandidatesReferences".DBCC results for 'sys.ifts_comp_fragment_1630628852_197286'.There are 2304 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197286".DBCC results for 'sys.ifts_comp_fragment_1630628852_196615'.There are 1927 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196615".DBCC results for 'sys.ifts_comp_fragment_1630628852_197823'.There are 2058 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197823".DBCC results for 'sys.ifts_comp_fragment_1630628852_197689'.There are 1797 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197689".DBCC results for 'sys.ifts_comp_fragment_1630628852_196213'.There are 1871 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196213".DBCC results for 'sys.ifts_comp_fragment_1630628852_196079'.There are 2001 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196079".DBCC results for 'sys.ifts_comp_fragment_1630628852_195945'.There are 1729 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195945".DBCC results for 'sys.ifts_comp_fragment_1630628852_197019'.There are 3151 rows in 20 pages for object "sys.ifts_comp_fragment_1630628852_197019".DBCC results for 'sys.ifts_comp_fragment_1630628852_198227'.There are 1851 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_198227".DBCC results for 'sys.ifts_comp_fragment_1630628852_196348'.There are 2080 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196348".DBCC results for 'sys.ifts_comp_fragment_1630628852_197422'.There are 2120 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197422".DBCC results for 'DocumentType'.There are 5 rows in 1 pages for object "DocumentType".DBCC results for 'sys.ifts_comp_fragment_1630628852_196617'.There are 1728 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196617".DBCC results for 'sys.ifts_comp_fragment_1630628852_197825'.There are 1657 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197825".DBCC results for 'sys.ifts_comp_fragment_1630628852_197691'.There are 1758 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197691".DBCC results for 'ApplicantSearches'.There are 2 rows in 1 pages for object "ApplicantSearches".DBCC results for 'sys.ifts_comp_fragment_1630628852_195947'.There are 1634 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195947".DBCC results for 'sys.ifts_comp_fragment_1630628852_197424'.There are 1825 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197424".DBCC results for 'sys.ifts_comp_fragment_1630628852_196753'.There are 2045 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196753".DBCC results for 'sys.ifts_comp_fragment_1630628852_197290'.There are 2611 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_197290".DBCC results for 'sys.ifts_comp_fragment_1630628852_197156'.There are 2336 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197156".DBCC results for 'CustomerTrialAdvertCredit'.There are 34 rows in 1 pages for object "CustomerTrialAdvertCredit".DBCC results for 'sys.ifts_comp_fragment_1630628852_196217'.There are 1548 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196217".DBCC results for 'sys.ifts_comp_fragment_1630628852_197828'.There are 2232 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197828".DBCC results for 'sys.ifts_comp_fragment_1630628852_197694'.There are 2367 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197694".DBCC results for 'CompanyRanks'.There are 8 rows in 1 pages for object "CompanyRanks".DBCC results for 'sys.ifts_comp_fragment_1630628852_195815'.There are 2849 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_195815".DBCC results for 'sys.ifts_comp_fragment_1630628852_197426'.There are 2162 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197426".DBCC results for 'sys.ifts_comp_fragment_1630628852_197158'.There are 1705 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197158".DBCC results for 'CompanySearch'.There are 13 rows in 1 pages for object "CompanySearch".DBCC results for 'sys.ifts_comp_fragment_1630628852_195817'.There are 2225 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_195817".DBCC results for 'sys.ifts_comp_fragment_1630628852_197562'.There are 2524 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_197562".DBCC results for 'sys.ifts_comp_fragment_1630628852_196891'.There are 2108 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196891".DBCC results for 'sys.ifts_comp_fragment_1630628852_196757'.There are 1809 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196757".DBCC results for 'sys.ifts_comp_fragment_1630628852_196087'.There are 2491 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_196087".DBCC results for 'DefaultNotes'.There are 0 rows in 0 pages for object "DefaultNotes".DBCC results for 'sys.ifts_comp_fragment_1630628852_195819'.There are 1592 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195819".DBCC results for 'sys.ifts_comp_fragment_1630628852_197564'.There are 1770 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197564".DBCC results for 'sys.ifts_comp_fragment_1630628852_196893'.There are 2131 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196893".DBCC results for 'sys.ifts_comp_fragment_1630628852_198101'.There are 1647 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198101".DBCC results for 'sys.ifts_comp_fragment_1630628852_197967'.There are 1664 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197967".DBCC results for 'sys.ifts_comp_fragment_1630628852_197431'.There are 1951 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197431".DBCC results for 'IndustrySector'.There are 163 rows in 1 pages for object "IndustrySector".DBCC results for 'sys.ifts_comp_fragment_1630628852_195821'.There are 1728 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195821".DBCC results for 'sys.ifts_comp_fragment_1630628852_197029'.There are 1614 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_197029".DBCC results for 'sys.ifts_comp_fragment_1630628852_197164'.There are 1658 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197164".DBCC results for 'sys.ifts_comp_fragment_1630628852_196493'.There are 1867 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196493".DBCC results for 'sys.ifts_comp_fragment_1630628852_196225'.There are 1724 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196225".DBCC results for 'sys.ifts_comp_fragment_1630628852_196091'.There are 2463 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_196091".DBCC results for 'sys.ifts_comp_fragment_1630628852_195957'.There are 1885 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_195957".DBCC results for 'NoteType'.There are 12 rows in 1 pages for object "NoteType".DBCC results for 'sys.ifts_comp_fragment_1630628852_197568'.There are 2479 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_197568".DBCC results for 'VF_log_sql'.There are 0 rows in 0 pages for object "VF_log_sql".DBCC results for 'ISVGroups'.There are 17 rows in 1 pages for object "ISVGroups".DBCC results for 'sys.ifts_comp_fragment_1630628852_197971'.There are 1668 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197971".DBCC results for 'sys.ifts_comp_fragment_1630628852_197166'.There are 1680 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197166".DBCC results for 'sys.ifts_comp_fragment_1630628852_196495'.There are 2723 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_196495".DBCC results for 'VF_log_errors'.There are 66959 rows in 2413 pages for object "VF_log_errors".DBCC results for 'sys.ifts_comp_fragment_1630628852_195959'.There are 2649 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_195959".DBCC results for 'sys.ifts_comp_fragment_1630628852_195825'.There are 1593 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_195825".DBCC results for 'sys.ifts_comp_fragment_1630628852_197570'.There are 1893 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197570".DBCC results for 'sys.ifts_comp_fragment_1630628852_196631'.There are 1579 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196631".DBCC results for 'sys.ifts_comp_fragment_1630628852_197168'.There are 3284 rows in 22 pages for object "sys.ifts_comp_fragment_1630628852_197168".DBCC results for 'CompanySize'.There are 5 rows in 1 pages for object "CompanySize".DBCC results for 'sys.ifts_comp_fragment_1630628852_198108'.There are 3050 rows in 20 pages for object "sys.ifts_comp_fragment_1630628852_198108".DBCC results for 'sys.ifts_comp_fragment_1630628852_195961'.There are 1769 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195961".DBCC results for 'sys.ifts_comp_fragment_1630628852_195827'.There are 1867 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195827".DBCC results for 'sys.ifts_comp_fragment_1630628852_196364'.There are 1861 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196364".DBCC results for 'AdvertStages'.There are 11 rows in 1 pages for object "AdvertStages".DBCC results for 'sys.ifts_comp_fragment_1630628852_196767'.There are 1851 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196767".DBCC results for 'CallBack'.There are 21188 rows in 141 pages for object "CallBack".DBCC results for 'sys.ifts_comp_fragment_1630628852_197170'.There are 2425 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197170".DBCC results for 'sys.ifts_comp_fragment_1630628852_197573'.There are 17154 rows in 141 pages for object "sys.ifts_comp_fragment_1630628852_197573".DBCC results for 'sys.ifts_comp_fragment_1630628852_198110'.There are 2090 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_198110".DBCC results for 'sys.ifts_comp_fragment_1630628852_196634'.There are 17472 rows in 148 pages for object "sys.ifts_comp_fragment_1630628852_196634".DBCC results for 'sys.ifts_comp_fragment_1630628852_197842'.There are 2592 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_197842".DBCC results for 'sys.ifts_comp_fragment_1630628852_195694'.There are 21083 rows in 188 pages for object "sys.ifts_comp_fragment_1630628852_195694".DBCC results for 'sys.ifts_comp_fragment_1630628852_197977'.There are 1853 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197977".DBCC results for 'sys.ifts_comp_fragment_1630628852_195964'.There are 1877 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195964".DBCC results for 'sys.ifts_comp_fragment_1630628852_197038'.There are 1693 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197038".DBCC results for 'sys.ifts_comp_fragment_1630628852_197575'.There are 1947 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197575".DBCC results for 'sys.ifts_comp_fragment_1630628852_198112'.There are 3007 rows in 20 pages for object "sys.ifts_comp_fragment_1630628852_198112".DBCC results for 'sys.ifts_comp_fragment_1630628852_196636'.There are 2045 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196636".DBCC results for 'sys.ifts_comp_fragment_1630628852_195831'.There are 1782 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195831".DBCC results for 'ApplicantProfile'.There are 2208 rows in 83 pages for object "ApplicantProfile".DBCC results for 'sys.ifts_comp_fragment_1630628852_196368'.There are 1715 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196368".DBCC results for 'sys.ifts_comp_fragment_1630628852_196905'.There are 1676 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196905".DBCC results for 'sys.ifts_comp_fragment_1630628852_197577'.There are 2796 rows in 19 pages for object "sys.ifts_comp_fragment_1630628852_197577".DBCC results for 'sys.ifts_comp_fragment_1630628852_196638'.There are 1785 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196638".DBCC results for 'Reference'.There are 34463 rows in 242 pages for object "Reference".DBCC results for 'EmailOutQueue'.There are 34656 rows in 6942 pages for object "EmailOutQueue".DBCC results for 'sys.ifts_comp_fragment_1630628852_197981'.There are 1792 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197981".DBCC results for 'sys.ifts_comp_fragment_1630628852_195968'.There are 2287 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_195968".DBCC results for 'sys.ifts_comp_fragment_1630628852_196103'.There are 1584 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196103".DBCC results for 'sys.ifts_comp_fragment_1630628852_198251'.There are 1790 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_198251".DBCC results for 'sys.ifts_comp_fragment_1630628852_196909'.There are 1706 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196909".DBCC results for 'sys.ifts_comp_fragment_1630628852_197446'.There are 1648 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197446".DBCC results for 'sys.ifts_comp_fragment_1630628852_196374'.There are 2220 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196374".DBCC results for 'sys.ifts_comp_fragment_1630628852_198119'.There are 16271 rows in 145 pages for object "sys.ifts_comp_fragment_1630628852_198119".DBCC results for 'sys.ifts_comp_fragment_1630628852_197448'.There are 2058 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197448".DBCC results for 'UserAccessLevels'.There are 3 rows in 1 pages for object "UserAccessLevels".DBCC results for 'Industry'.There are 48 rows in 1 pages for object "Industry".DBCC results for 'sys.ifts_comp_fragment_1630628852_197583'.There are 2028 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197583".DBCC results for 'PaymentMaster'.There are 2 rows in 1 pages for object "PaymentMaster".DBCC results for 'sys.ifts_comp_fragment_1630628852_195570'.There are 868719 rows in 30526 pages for object "sys.ifts_comp_fragment_1630628852_195570".DBCC results for 'sys.ifts_comp_fragment_1630628852_196645'.There are 1756 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196645".DBCC results for 'sys.ifts_comp_fragment_1630628852_195974'.There are 18010 rows in 148 pages for object "sys.ifts_comp_fragment_1630628852_195974".DBCC results for 'sys.ifts_comp_fragment_1630628852_197585'.There are 1587 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197585".DBCC results for 'sys.ifts_comp_fragment_1630628852_197988'.There are 3504 rows in 24 pages for object "sys.ifts_comp_fragment_1630628852_197988".DBCC results for 'sys.ifts_comp_fragment_1630628852_197854'.There are 2371 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197854".DBCC results for 'sys.ifts_comp_fragment_1630628852_195841'.There are 1844 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195841".DBCC results for 'CompanyTheme'.There are 210 rows in 2 pages for object "CompanyTheme".DBCC results for 'SplashUsers'.There are 4 rows in 1 pages for object "SplashUsers".DBCC results for 'sys.ifts_comp_fragment_1630628852_197318'.There are 1772 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197318".DBCC results for 'sys.ifts_comp_fragment_1630628852_196647'.There are 1910 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196647".DBCC results for 'sys.ifts_comp_fragment_1630628852_195976'.There are 2159 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_195976".DBCC results for 'sys.fulltext_index_docidstatus_1630628852'.There are 0 rows in 1 pages for object "sys.fulltext_index_docidstatus_1630628852".DBCC results for 'sys.ifts_comp_fragment_1630628852_198258'.There are 15883 rows in 141 pages for object "sys.ifts_comp_fragment_1630628852_198258".DBCC results for 'sys.ifts_comp_fragment_1630628852_197587'.There are 1668 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197587".DBCC results for 'sys.ifts_comp_fragment_1630628852_197453'.There are 2447 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197453".DBCC results for 'sys.ifts_comp_fragment_1630628852_197856'.There are 2664 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_197856".DBCC results for 'sys.ifts_comp_fragment_1630628852_196514'.There are 1739 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196514".DBCC results for 'sys.ifts_comp_fragment_1630628852_195843'.There are 1738 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195843".DBCC results for 'sys.fulltext_docidfilter_1630628852'.There are 46185 rows in 149 pages for object "sys.fulltext_docidfilter_1630628852".DBCC results for 'sys.ifts_comp_fragment_1630628852_174901'.There are 700305 rows in 24170 pages for object "sys.ifts_comp_fragment_1630628852_174901".DBCC results for 'sys.ifts_comp_fragment_1630628852_196380'.There are 2277 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_196380".DBCC results for 'sys.ifts_comp_fragment_1630628852_196246'.There are 1724 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196246".DBCC results for 'sys.ifts_comp_fragment_1630628852_197320'.There are 1798 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197320".DBCC results for 'sys.ifts_comp_fragment_1630628852_195978'.There are 2159 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_195978".DBCC results for 'sys.fulltext_indexeddocid_1630628852'.There are 96240 rows in 203 pages for object "sys.fulltext_indexeddocid_1630628852".DBCC results for 'sys.ifts_comp_fragment_1630628852_198260'.There are 1110 rows in 7 pages for object "sys.ifts_comp_fragment_1630628852_198260".DBCC results for 'sys.ifts_comp_fragment_1630628852_197589'.There are 1723 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197589".DBCC results for 'sys.ifts_comp_fragment_1630628852_198126'.There are 1817 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_198126".DBCC results for 'SplashVideos'.There are 27 rows in 2 pages for object "SplashVideos".DBCC results for 'sys.ifts_comp_fragment_1630628852_197992'.There are 2264 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197992".DBCC results for 'sys.fulltext_avdl_1630628852'.There are 5 rows in 1 pages for object "sys.fulltext_avdl_1630628852".DBCC results for 'AdvertHistory'.There are 21335 rows in 639 pages for object "AdvertHistory".DBCC results for 'sys.ifts_comp_fragment_1630628852_196248'.There are 1728 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196248".DBCC results for 'sys.ifts_comp_fragment_1630628852_196785'.There are 2114 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196785".DBCC results for 'sys.ifts_comp_fragment_1630628852_198262'.There are 898 rows in 6 pages for object "sys.ifts_comp_fragment_1630628852_198262".DBCC results for 'sys.ifts_comp_fragment_1630628852_197996'.There are 1670 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197996".DBCC results for 'sys.ifts_comp_fragment_1630628852_195849'.There are 1952 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195849".DBCC results for 'sys.ifts_comp_fragment_1630628852_198265'.There are 2124 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_198265".DBCC results for 'sys.ifts_comp_fragment_1630628852_196655'.There are 1786 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196655".DBCC results for 'sys.ifts_comp_fragment_1630628852_197863'.There are 2288 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197863".DBCC results for 'sys.ifts_comp_fragment_1630628852_196387'.There are 1710 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196387".DBCC results for 'sys.ifts_comp_fragment_1630628852_196119'.There are 1764 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196119".DBCC results for 'CustomerEmailTemplate'.There are 40 rows in 1 pages for object "CustomerEmailTemplate".DBCC results for 'sys.ifts_comp_fragment_1630628852_197193'.There are 1915 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197193".DBCC results for 'sys.ifts_comp_fragment_1630628852_198267'.There are 1904 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_198267".DBCC results for 'sys.ifts_comp_fragment_1630628852_196791'.There are 1821 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196791".DBCC results for 'sys.ifts_comp_fragment_1630628852_197999'.There are 2185 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197999".DBCC results for 'sys.ifts_comp_fragment_1630628852_197328'.There are 1900 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197328".DBCC results for 'sys.ifts_comp_fragment_1630628852_196657'.There are 2029 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196657".DBCC results for 'sys.ifts_comp_fragment_1630628852_196389'.There are 1710 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196389".DBCC results for 'sys.ifts_comp_fragment_1630628852_197597'.There are 1779 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197597".DBCC results for 'sys.ifts_comp_fragment_1630628852_196121'.There are 1652 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196121".DBCC results for 'Jobsites'.There are 6 rows in 1 pages for object "Jobsites".DBCC results for 'sys.ifts_comp_fragment_1630628852_195987'.There are 1703 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195987".DBCC results for 'sys.ifts_comp_fragment_1630628852_196524'.There are 2593 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_196524".DBCC results for 'sys.ifts_comp_fragment_1630628852_198269'.There are 2160 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_198269".DBCC results for 'sys.ifts_comp_fragment_1630628852_197464'.There are 1749 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197464".DBCC results for 'MasterNumber'.There are 3 rows in 1 pages for object "MasterNumber".DBCC results for 'sys.ifts_comp_fragment_1630628852_196659'.There are 2034 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196659".DBCC results for 'sys.ifts_comp_fragment_1630628852_195854'.There are 2745 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_195854".DBCC results for 'sys.ifts_comp_fragment_1630628852_196391'.There are 1710 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196391".DBCC results for 'sys.ifts_comp_fragment_1630628852_197599'.There are 1669 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197599".DBCC results for 'sys.ifts_comp_fragment_1630628852_195989'.There are 1707 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195989".DBCC results for 'sys.ifts_comp_fragment_1630628852_197063'.There are 2281 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197063".DBCC results for 'sys.ifts_comp_fragment_1630628852_198271'.There are 3648 rows in 25 pages for object "sys.ifts_comp_fragment_1630628852_198271".DBCC results for 'AdvertAccess'.There are 1554 rows in 5 pages for object "AdvertAccess".DBCC results for 'DisabledReasons'.There are 3 rows in 1 pages for object "DisabledReasons".DBCC results for 'sys.ifts_comp_fragment_1630628852_196661'.There are 1968 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196661".DBCC results for 'sys.ifts_comp_fragment_1630628852_197601'.There are 1669 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197601".DBCC results for 'ResponseStatus'.There are 2 rows in 1 pages for object "ResponseStatus".DBCC results for 'sys.ifts_comp_fragment_1630628852_195991'.There are 1729 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195991".DBCC results for 'sys.ifts_comp_fragment_1630628852_197065'.There are 3143 rows in 22 pages for object "sys.ifts_comp_fragment_1630628852_197065".DBCC results for 'sys.ifts_comp_fragment_1630628852_198273'.There are 862 rows in 6 pages for object "sys.ifts_comp_fragment_1630628852_198273".DBCC results for 'sys.ifts_comp_fragment_1630628852_198139'.There are 1696 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198139".DBCC results for 'sys.ifts_comp_fragment_1630628852_196797'.There are 2406 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_196797".DBCC results for 'sys.ifts_comp_fragment_1630628852_197737'.There are 2108 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197737".DBCC results for 'sys.ifts_comp_fragment_1630628852_195858'.There are 2089 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_195858".DBCC results for 'sys.ifts_comp_fragment_1630628852_196932'.There are 2292 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_196932".DBCC results for 'QuotesDetails'.There are 12 rows in 1 pages for object "QuotesDetails".DBCC results for 'sys.ifts_comp_fragment_1630628852_196127'.There are 2639 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_196127".DBCC results for 'SalaryPeriod'.There are 5 rows in 1 pages for object "SalaryPeriod".DBCC results for 'sys.ifts_comp_fragment_1630628852_197872'.There are 2786 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_197872".DBCC results for 'sys.ifts_comp_fragment_1630628852_195993'.There are 1840 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195993".DBCC results for 'sys.ifts_comp_fragment_1630628852_197067'.There are 3065 rows in 20 pages for object "sys.ifts_comp_fragment_1630628852_197067".DBCC results for 'sys.ifts_comp_fragment_1630628852_197604'.There are 1718 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197604".DBCC results for 'sys.ifts_comp_fragment_1630628852_198141'.There are 1699 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198141".DBCC results for 'sys.ifts_comp_fragment_1630628852_196799'.There are 3387 rows in 22 pages for object "sys.ifts_comp_fragment_1630628852_196799".DBCC results for 'sys.ifts_comp_fragment_1630628852_195860'.There are 2146 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_195860".DBCC results for 'sys.ifts_comp_fragment_1630628852_198276'.There are 1656 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198276".DBCC results for 'sys.ifts_comp_fragment_1630628852_196934'.There are 1843 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196934".DBCC results for 'QuotesMaster'.There are 10 rows in 1 pages for object "QuotesMaster".DBCC results for 'RankHistory'.There are 32858 rows in 167 pages for object "RankHistory".DBCC results for 'sys.ifts_comp_fragment_1630628852_196801'.There are 1994 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196801".DBCC results for 'sys.ifts_comp_fragment_1630628852_196130'.There are 2100 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196130".DBCC results for 'sys.ifts_comp_fragment_1630628852_196667'.There are 1646 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196667".DBCC results for 'JobType'.There are 4 rows in 1 pages for object "JobType".DBCC results for 'sys.ifts_comp_fragment_1630628852_198278'.There are 1560 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_198278".DBCC results for 'sys.ifts_comp_fragment_1630628852_196936'.There are 1888 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196936".DBCC results for 'sys.ifts_comp_fragment_1630628852_198010'.There are 1741 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198010".DBCC results for 'sys.ifts_comp_fragment_1630628852_196534'.There are 1753 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196534".DBCC results for 'sys.ifts_comp_fragment_1630628852_198145'.There are 1720 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198145".DBCC results for 'sys.ifts_comp_fragment_1630628852_196266'.There are 2226 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196266".DBCC results for 'AdvertResponse'.There are 150767 rows in 5008 pages for object "AdvertResponse".DBCC results for 'sys.ifts_comp_fragment_1630628852_197340'.There are 1586 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_197340".DBCC results for 'sys.ifts_comp_fragment_1630628852_198280'.There are 717 rows in 5 pages for object "sys.ifts_comp_fragment_1630628852_198280".DBCC results for 'sys.ifts_comp_fragment_1630628852_196938'.There are 2199 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196938".DBCC results for 'CompanyInformation'.There are 281 rows in 4 pages for object "CompanyInformation".DBCC results for 'sys.ifts_comp_fragment_1630628852_198012'.There are 1657 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198012".DBCC results for 'sys.ifts_comp_fragment_1630628852_198147'.There are 2413 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_198147".DBCC results for 'sys.ifts_comp_fragment_1630628852_196268'.There are 2226 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196268".DBCC results for 'sys.ifts_comp_fragment_1630628852_196134'.There are 1859 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196134".DBCC results for 'sys.ifts_comp_fragment_1630628852_197879'.There are 2266 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197879".DBCC results for 'CustomerTrialAction'.There are 3 rows in 1 pages for object "CustomerTrialAction".DBCC results for 'sys.ifts_comp_fragment_1630628852_195866'.There are 1718 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195866".DBCC results for 'sys.ifts_comp_fragment_1630628852_196940'.There are 1955 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196940".DBCC results for 'ContactsEmails'.There are 576 rows in 12 pages for object "ContactsEmails".DBCC results for 'sys.ifts_comp_fragment_1630628852_198283'.There are 776 rows in 5 pages for object "sys.ifts_comp_fragment_1630628852_198283".DBCC results for 'CustomerTrialPackage'.There are 3 rows in 1 pages for object "CustomerTrialPackage".DBCC results for 'sys.ifts_comp_fragment_1630628852_197747'.There are 2428 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197747".DBCC results for 'sys.ifts_comp_fragment_1630628852_195868'.There are 2155 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_195868".DBCC results for 'sys.ifts_comp_fragment_1630628852_196942'.There are 1977 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196942".DBCC results for 'sys.ifts_comp_fragment_1630628852_196808'.There are 19290 rows in 157 pages for object "sys.ifts_comp_fragment_1630628852_196808".DBCC results for 'ISVTests'.There are 3023 rows in 33 pages for object "ISVTests".DBCC results for 'CustomerTrialPaymentMethod'.There are 5 rows in 1 pages for object "CustomerTrialPaymentMethod".DBCC results for 'sys.ifts_comp_fragment_1630628852_198285'.There are 957 rows in 6 pages for object "sys.ifts_comp_fragment_1630628852_198285".DBCC results for 'sys.ifts_comp_fragment_1630628852_197614'.There are 1716 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197614".DBCC results for 'sys.ifts_comp_fragment_1630628852_197346'.There are 1587 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_197346".DBCC results for 'CustomerTrialStage'.There are 5 rows in 1 pages for object "CustomerTrialStage".DBCC results for 'sys.ifts_comp_fragment_1630628852_195870'.There are 2004 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_195870".DBCC results for 'ZIData'.There are 727 rows in 56 pages for object "ZIData".DBCC results for 'sys.ifts_comp_fragment_1630628852_198018'.There are 2554 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_198018".DBCC results for 'sys.ifts_comp_fragment_1630628852_196005'.There are 2688 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_196005".DBCC results for 'sys.ifts_comp_fragment_1630628852_198287'.There are 1022 rows in 7 pages for object "sys.ifts_comp_fragment_1630628852_198287".DBCC results for 'sys.ifts_comp_fragment_1630628852_197616'.There are 1789 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197616".DBCC results for 'sys.ifts_comp_fragment_1630628852_197751'.There are 16007 rows in 133 pages for object "sys.ifts_comp_fragment_1630628852_197751".DBCC results for 'sys.ifts_comp_fragment_1630628852_195872'.There are 1670 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195872".DBCC results for 'sys.ifts_comp_fragment_1630628852_197080'.There are 2002 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197080".DBCC results for 'sys.ifts_comp_fragment_1630628852_198020'.There are 1676 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198020".DBCC results for 'sys.ifts_comp_fragment_1630628852_196007'.There are 1838 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196007".DBCC results for 'sys.ifts_comp_fragment_1630628852_197484'.There are 2251 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197484".DBCC results for 'sys.ifts_comp_fragment_1630628852_195874'.There are 2044 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_195874".DBCC results for 'sys.ifts_comp_fragment_1630628852_198290'.There are 1212 rows in 8 pages for object "sys.ifts_comp_fragment_1630628852_198290".DBCC results for 'sys.ifts_comp_fragment_1630628852_196948'.There are 1955 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196948".DBCC results for 'AdvertResponseAnnotation'.There are 19563 rows in 200 pages for object "AdvertResponseAnnotation".DBCC results for 'sys.ifts_comp_fragment_1630628852_197888'.There are 1699 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197888".DBCC results for 'sys.ifts_comp_fragment_1630628852_196009'.There are 2090 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196009".DBCC results for 'sys.ifts_comp_fragment_1630628852_197083'.There are 2021 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197083".DBCC results for 'AccessType'.There are 2 rows in 1 pages for object "AccessType".DBCC results for 'sys.ifts_comp_fragment_1630628852_198292'.There are 1644 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198292".DBCC results for 'sys.ifts_comp_fragment_1630628852_196950'.There are 1976 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196950".DBCC results for 'sys.ifts_comp_fragment_1630628852_196816'.There are 1628 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196816".DBCC results for 'Emails'.There are 34132 rows in 4407 pages for object "Emails".DBCC results for 'sys.ifts_comp_fragment_1630628852_198024'.There are 2293 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_198024".DBCC results for 'sys.ifts_comp_fragment_1630628852_196145'.There are 2100 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196145".DBCC results for 'sys.ifts_comp_fragment_1630628852_196011'.There are 2124 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196011".DBCC results for 'sys.ifts_comp_fragment_1630628852_198294'.There are 2669 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_198294".DBCC results for 'sys.ifts_comp_fragment_1630628852_196415'.There are 2242 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_196415".DBCC results for 'sys.ifts_comp_fragment_1630628852_196147'.There are 2100 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196147".DBCC results for 'sysdiagrams'.There are 1 rows in 1 pages for object "sysdiagrams".DBCC results for 'sys.ifts_comp_fragment_1630628852_195879'.There are 3434 rows in 23 pages for object "sys.ifts_comp_fragment_1630628852_195879".DBCC results for 'CustomerTrialPaymentDetails'.There are 29 rows in 1 pages for object "CustomerTrialPaymentDetails".DBCC results for 'sys.ifts_comp_fragment_1630628852_196551'.There are 2104 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196551".DBCC results for 'sys.ifts_comp_fragment_1630628852_198296'.There are 2078 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_198296".DBCC results for 'sys.ifts_comp_fragment_1630628852_197625'.There are 2744 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_197625".DBCC results for 'PersonName'.There are 130842 rows in 1439 pages for object "PersonName".DBCC results for 'sys.ifts_comp_fragment_1630628852_196418'.There are 2465 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_196418".DBCC results for 'sys.ifts_comp_fragment_1630628852_196955'.There are 16004 rows in 129 pages for object "sys.ifts_comp_fragment_1630628852_196955".DBCC results for 'CompanyGroups'.There are 41 rows in 1 pages for object "CompanyGroups".DBCC results for 'sys.ifts_comp_fragment_1630628852_196687'.There are 3499 rows in 24 pages for object "sys.ifts_comp_fragment_1630628852_196687".DBCC results for 'sys.ifts_comp_fragment_1630628852_197895'.There are 1927 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197895".DBCC results for 'sys.ifts_comp_fragment_1630628852_196016'.There are 1946 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196016".DBCC results for 'sys.ifts_comp_fragment_1630628852_195882'.There are 3821 rows in 25 pages for object "sys.ifts_comp_fragment_1630628852_195882".DBCC results for 'sys.ifts_comp_fragment_1630628852_198298'.There are 2552 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_198298".DBCC results for 'EntityId'.There are 96265 rows in 346 pages for object "EntityId".DBCC results for 'sys.ifts_comp_fragment_1630628852_196554'.There are 2259 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_196554".DBCC results for 'sys.ifts_comp_fragment_1630628852_196420'.There are 1967 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196420".DBCC results for 'sys.ifts_comp_fragment_1630628852_197897'.There are 1729 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197897".DBCC results for 'sys.ifts_comp_fragment_1630628852_196018'.There are 2060 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196018".DBCC results for 'sys.ifts_comp_fragment_1630628852_195884'.There are 2382 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_195884".DBCC results for 'sys.ifts_comp_fragment_1630628852_198300'.There are 1214 rows in 8 pages for object "sys.ifts_comp_fragment_1630628852_198300".DBCC results for 'Credential'.There are 83689 rows in 1773 pages for object "Credential".DBCC results for 'ApplicantRehab'.There are 141 rows in 2 pages for object "ApplicantRehab".DBCC results for 'sys.ifts_comp_fragment_1630628852_196422'.There are 2610 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_196422".DBCC results for 'sys.ifts_comp_fragment_1630628852_195750'.There are 11246 rows in 88 pages for object "sys.ifts_comp_fragment_1630628852_195750".DBCC results for 'sys.ifts_comp_fragment_1630628852_196288'.There are 2237 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_196288".DBCC results for 'sys.ifts_comp_fragment_1630628852_195886'.There are 3341 rows in 22 pages for object "sys.ifts_comp_fragment_1630628852_195886".DBCC results for 'sys.ifts_comp_fragment_1630628852_198302'.There are 1280 rows in 8 pages for object "sys.ifts_comp_fragment_1630628852_198302".DBCC results for 'PostalAddress'.There are 505638 rows in 4305 pages for object "PostalAddress".DBCC results for 'sys.ifts_comp_fragment_1630628852_198034'.There are 1888 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_198034".DBCC results for 'sys.ifts_comp_fragment_1630628852_197766'.There are 1604 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197766".DBCC results for 'sys.ifts_comp_fragment_1630628852_196424'.There are 1996 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196424".DBCC results for 'sys.ifts_comp_fragment_1630628852_198169'.There are 2319 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_198169".DBCC results for 'sys.ifts_comp_fragment_1630628852_196290'.There are 1820 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196290".DBCC results for 'sys.ifts_comp_fragment_1630628852_196693'.There are 2124 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196693".DBCC results for 'sys.ifts_comp_fragment_1630628852_197230'.There are 1955 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197230".DBCC results for 'sys.ifts_comp_fragment_1630628852_195888'.There are 2295 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_195888".DBCC results for 'sys.ifts_comp_fragment_1630628852_198304'.There are 651 rows in 4 pages for object "sys.ifts_comp_fragment_1630628852_198304".DBCC results for 'sys.ifts_comp_fragment_1630628852_196023'.There are 1651 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196023".DBCC results for 'sys.ifts_comp_fragment_1630628852_196560'.There are 2524 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_196560".DBCC results for 'CustomerTrial'.There are 31 rows in 4 pages for object "CustomerTrial".DBCC results for 'sys.ifts_comp_fragment_1630628852_197768'.There are 2077 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197768".DBCC results for 'sys.ifts_comp_fragment_1630628852_196292'.There are 1880 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196292".DBCC results for 'sys.ifts_comp_fragment_1630628852_197500'.There are 1954 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197500".DBCC results for 'sys.ifts_comp_fragment_1630628852_196158'.There are 18349 rows in 151 pages for object "sys.ifts_comp_fragment_1630628852_196158".DBCC results for 'sys.ifts_comp_fragment_1630628852_197366'.There are 1623 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197366".DBCC results for 'sys.ifts_comp_fragment_1630628852_197232'.There are 1978 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197232".DBCC results for 'sys.filetable_updates_1627724376'.There are 0 rows in 0 pages for object "sys.filetable_updates_1627724376".DBCC results for 'sys.ifts_comp_fragment_1630628852_196964'.There are 1637 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196964".DBCC results for 'Resume'.There are 96240 rows in 75097 pages for object "Resume".DBCC results for 'Advert'.There are 2082 rows in 242 pages for object "Advert".DBCC results for 'sys.ifts_comp_fragment_1630628852_197099'.There are 1709 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197099".DBCC results for 'sys.ifts_comp_fragment_1630628852_198039'.There are 2783 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_198039".DBCC results for 'sys.ifts_comp_fragment_1630628852_197368'.There are 1657 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197368".DBCC results for 'sys.ifts_comp_fragment_1630628852_197905'.There are 2392 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197905".DBCC results for 'sys.ifts_comp_fragment_1630628852_196026'.There are 2264 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_196026".DBCC results for 'sys.ifts_comp_fragment_1630628852_196563'.There are 1871 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196563".DBCC results for 'sys.ifts_comp_fragment_1630628852_195892'.There are 2233 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_195892".DBCC results for 'sys.ifts_comp_fragment_1630628852_196966'.There are 2320 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_196966".DBCC results for 'EntityIdValue'.There are 6 rows in 1 pages for object "EntityIdValue".DBCC results for 'ISVExercises'.There are 170 rows in 5 pages for object "ISVExercises".DBCC results for 'sys.ifts_comp_fragment_1630628852_197235'.There are 3041 rows in 20 pages for object "sys.ifts_comp_fragment_1630628852_197235".DBCC results for 'sys.ifts_comp_fragment_1630628852_197772'.There are 2337 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197772".DBCC results for 'sys.ifts_comp_fragment_1630628852_198041'.There are 1766 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_198041".DBCC results for 'sys.ifts_comp_fragment_1630628852_197370'.There are 1995 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197370".DBCC results for 'Country'.There are 45 rows in 1 pages for object "Country".DBCC results for 'sys.ifts_comp_fragment_1630628852_195894'.There are 1909 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_195894".DBCC results for 'JobCategory'.There are 0 rows in 0 pages for object "JobCategory".DBCC results for 'Currency'.There are 3 rows in 1 pages for object "Currency".DBCC results for 'sys.ifts_comp_fragment_1630628852_195760'.Repair: The Clustered index successfully rebuilt for the object "sys.ifts_comp_fragment_1630628852_195760" in database "VF".Repair: The page (1:2240096) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240097) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240098) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240099) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240100) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240101) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240102) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240103) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240104) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240105) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240106) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240107) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240108) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240109) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240110) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240111) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240112) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240113) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240114) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240115) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240116) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240117) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240118) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240119) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240120) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240121) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240122) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240123) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Repair: The page (1:2240124) has been deallocated from object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data).Msg 8945, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1 will be rebuilt. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240096) could not be processed. See other errors for details. The error has been repaired.Msg 8976, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Page (1:2240096) was not seen in the scan although its parent (1:1356704) and previous (1:1526789) refer to it. Check any previous errors. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240097) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 8 refers to child page (1:2240097) and previous child (1:2240096), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240098) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 9 refers to child page (1:2240098) and previous child (1:2240097), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240099) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 10 refers to child page (1:2240099) and previous child (1:2240098), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240100) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 11 refers to child page (1:2240100) and previous child (1:2240099), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240101) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 12 refers to child page (1:2240101) and previous child (1:2240100), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240102) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 13 refers to child page (1:2240102) and previous child (1:2240101), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240103) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 14 refers to child page (1:2240103) and previous child (1:2240102), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240104) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 15 refers to child page (1:2240104) and previous child (1:2240103), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240105) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 16 refers to child page (1:2240105) and previous child (1:2240104), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240106) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 17 refers to child page (1:2240106) and previous child (1:2240105), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240107) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 18 refers to child page (1:2240107) and previous child (1:2240106), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240108) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 19 refers to child page (1:2240108) and previous child (1:2240107), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240109) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 20 refers to child page (1:2240109) and previous child (1:2240108), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240110) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 21 refers to child page (1:2240110) and previous child (1:2240109), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240111) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 22 refers to child page (1:2240111) and previous child (1:2240110), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240112) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 23 refers to child page (1:2240112) and previous child (1:2240111), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240113) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 24 refers to child page (1:2240113) and previous child (1:2240112), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240114) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 25 refers to child page (1:2240114) and previous child (1:2240113), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240115) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 26 refers to child page (1:2240115) and previous child (1:2240114), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240116) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 27 refers to child page (1:2240116) and previous child (1:2240115), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240117) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 28 refers to child page (1:2240117) and previous child (1:2240116), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240118) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 29 refers to child page (1:2240118) and previous child (1:2240117), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240119) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 30 refers to child page (1:2240119) and previous child (1:2240118), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240120) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 31 refers to child page (1:2240120) and previous child (1:2240119), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240121) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 32 refers to child page (1:2240121) and previous child (1:2240120), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240122) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 33 refers to child page (1:2240122) and previous child (1:2240121), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240123) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 34 refers to child page (1:2240123) and previous child (1:2240122), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data): Page (1:2240124) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1709768623, index ID 1, partition ID 72057606886326272, alloc unit ID 72057606897008640 (type In-row data). Index node page (1:1356704), slot 35 refers to child page (1:2240124) and previous child (1:2240123), but they were not encountered. The error has been repaired.There are 1171 rows in 7 pages for object "sys.ifts_comp_fragment_1630628852_195760".CHECKDB found 0 allocation errors and 58 consistency errors in table 'sys.ifts_comp_fragment_1630628852_195760' (object ID 1709768623).CHECKDB fixed 0 allocation errors and 58 consistency errors in table 'sys.ifts_comp_fragment_1630628852_195760' (object ID 1709768623).DBCC results for 'sys.ifts_comp_fragment_1630628852_197372'.There are 2027 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197372".DBCC results for 'sys.ifts_comp_fragment_1630628852_197909'.There are 1694 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197909".DBCC results for 'sys.ifts_comp_fragment_1630628852_196567'.There are 1667 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196567".DBCC results for 'sys.ifts_comp_fragment_1630628852_195761'.Repair: The Clustered index successfully rebuilt for the object "sys.ifts_comp_fragment_1630628852_195761" in database "VF".Repair: The page (1:2240128) has been deallocated from object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data).Repair: The page (1:2240129) has been deallocated from object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data).Repair: The page (1:2240130) has been deallocated from object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data).Msg 8945, Level 16, State 1, Line 6Table error: Object ID 1725768680, index ID 1 will be rebuilt. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240128) could not be processed. See other errors for details. The error has been repaired.Msg 8976, Level 16, State 1, Line 6Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Page (1:2240128) was not seen in the scan although its parent (1:1714459) and previous (1:1821640) refer to it. Check any previous errors. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240129) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Index node page (1:1714459), slot 8 refers to child page (1:2240129) and previous child (1:2240128), but they were not encountered. The error has been repaired.Msg 8928, Level 16, State 2, Line 6Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data): Page (1:2240130) could not be processed. See other errors for details. The error has been repaired.Msg 8980, Level 16, State 1, Line 6Table error: Object ID 1725768680, index ID 1, partition ID 72057606886391808, alloc unit ID 72057606897074176 (type In-row data). Index node page (1:1714459), slot 9 refers to child page (1:2240130) and previous child (1:2240129), but they were not encountered. The error has been repaired.There are 1140 rows in 7 pages for object "sys.ifts_comp_fragment_1630628852_195761".CHECKDB found 0 allocation errors and 6 consistency errors in table 'sys.ifts_comp_fragment_1630628852_195761' (object ID 1725768680).CHECKDB fixed 0 allocation errors and 6 consistency errors in table 'sys.ifts_comp_fragment_1630628852_195761' (object ID 1725768680).DBCC results for 'ResumeContactMethod'.There are 312971 rows in 937 pages for object "ResumeContactMethod".DBCC results for 'sys.ifts_comp_fragment_1630628852_196165'.There are 1744 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196165".DBCC results for 'sys.ifts_comp_fragment_1630628852_196702'.There are 1661 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196702".DBCC results for 'sys.ifts_comp_fragment_1630628852_196031'.There are 2064 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196031".DBCC results for 'sys.ifts_comp_fragment_1630628852_195897'.There are 1754 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_195897".DBCC results for 'sys.ifts_comp_fragment_1630628852_197105'.There are 1593 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_197105".DBCC results for 'sys.ifts_comp_fragment_1630628852_196434'.There are 2139 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196434".DBCC results for 'AdvertResponseNotes'.There are 5065 rows in 54 pages for object "AdvertResponseNotes".DBCC results for 'sys.ifts_comp_fragment_1630628852_198045'.There are 1680 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198045".DBCC results for 'AdvertDetail'.There are 24 rows in 1 pages for object "AdvertDetail".DBCC results for 'sys.ifts_comp_fragment_1630628852_197911'.There are 1581 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_197911".DBCC results for 'sys.ifts_comp_fragment_1630628852_197643'.There are 2295 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197643".DBCC results for 'sys.ifts_comp_fragment_1630628852_196972'.There are 1904 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196972".DBCC results for 'ReferenceContactMethod'.There are 2865 rows in 7 pages for object "ReferenceContactMethod".DBCC results for 'sys.ifts_comp_fragment_1630628852_197509'.There are 1599 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197509".DBCC results for 'sys.ifts_comp_fragment_1630628852_196167'.There are 1612 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196167".DBCC results for 'sys.ifts_comp_fragment_1630628852_196704'.There are 2208 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196704".DBCC results for 'ActionLog'.There are 104660 rows in 979 pages for object "ActionLog".DBCC results for 'sys.ifts_comp_fragment_1630628852_197107'.There are 1832 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197107".DBCC results for 'sys.ifts_comp_fragment_1630628852_196436'.There are 2139 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196436".DBCC results for 'sys.ifts_comp_fragment_1630628852_196302'.There are 2303 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_196302".DBCC results for 'sys.ifts_comp_fragment_1630628852_197913'.There are 2223 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197913".DBCC results for 'ApplicantRank'.There are 19 rows in 1 pages for object "ApplicantRank".DBCC results for 'sys.ifts_comp_fragment_1630628852_197645'.There are 2417 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197645".DBCC results for 'PhoneNumber'.There are 132543 rows in 903 pages for object "PhoneNumber".DBCC results for 'sys.ifts_comp_fragment_1630628852_197511'.There are 2026 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_197511".DBCC results for 'sys.ifts_comp_fragment_1630628852_196169'.There are 1650 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196169".DBCC results for 'sys.ifts_comp_fragment_1630628852_196706'.There are 1633 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196706".DBCC results for 'sys.ifts_comp_fragment_1630628852_197243'.There are 2246 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197243".DBCC results for 'InvoiceMaster'.There are 1422 rows in 49 pages for object "InvoiceMaster".DBCC results for 'sys.ifts_comp_fragment_1630628852_198049'.There are 1726 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_198049".DBCC results for 'sys.ifts_comp_fragment_1630628852_196036'.There are 1573 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196036".DBCC results for 'SMSReceived'.There are 471 rows in 7 pages for object "SMSReceived".DBCC results for 'sys.ifts_comp_fragment_1630628852_196976'.There are 2797 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_196976".DBCC results for 'PositionHistory'.There are 471677 rows in 73734 pages for object "PositionHistory".DBCC results for 'InvoiceDetails'.There are 1435 rows in 16 pages for object "InvoiceDetails".DBCC results for 'sys.ifts_comp_fragment_1630628852_197648'.There are 2229 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197648".DBCC results for 'ChatHistory'.There are 775 rows in 15 pages for object "ChatHistory".DBCC results for 'sys.ifts_comp_fragment_1630628852_197917'.There are 2131 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197917".DBCC results for 'sys.ifts_comp_fragment_1630628852_196038'.There are 1663 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196038".DBCC results for 'sys.ifts_comp_fragment_1630628852_196978'.There are 1799 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196978".DBCC results for 'DemoSiteVisit'.There are 2127 rows in 39 pages for object "DemoSiteVisit".DBCC results for 'AdditionalAnswers'.There are 0 rows in 0 pages for object "AdditionalAnswers".DBCC results for 'sys.ifts_comp_fragment_1630628852_197650'.There are 1733 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197650".DBCC results for 'sys.ifts_comp_fragment_1630628852_195771'.There are 2211 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_195771".DBCC results for 'SMS'.There are 4096 rows in 132 pages for object "SMS".DBCC results for 'sys.ifts_comp_fragment_1630628852_198053'.There are 2529 rows in 17 pages for object "sys.ifts_comp_fragment_1630628852_198053".DBCC results for 'TemplateType'.There are 3 rows in 1 pages for object "TemplateType".DBCC results for 'sys.ifts_comp_fragment_1630628852_198188'.There are 2219 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_198188".DBCC results for 'sys.ifts_comp_fragment_1630628852_195907'.There are 1847 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195907".DBCC results for 'sys.ifts_comp_fragment_1630628852_197115'.There are 2273 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197115".DBCC results for 'AdditionalQuestions'.There are 42 rows in 1 pages for object "AdditionalQuestions".DBCC results for 'sys.ifts_comp_fragment_1630628852_197652'.There are 1620 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197652".DBCC results for 'sys.ifts_comp_fragment_1630628852_196310'.There are 15378 rows in 133 pages for object "sys.ifts_comp_fragment_1630628852_196310".DBCC results for 'CallBackType'.There are 2 rows in 1 pages for object "CallBackType".DBCC results for 'sys.ifts_comp_fragment_1630628852_39762'.There are 677272 rows in 22329 pages for object "sys.ifts_comp_fragment_1630628852_39762".DBCC results for 'sys.ifts_comp_fragment_1630628852_197788'.There are 2064 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_197788".DBCC results for 'sys.ifts_comp_fragment_1630628852_195909'.There are 2298 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_195909".DBCC results for 'QuestionGroup'.There are 12 rows in 1 pages for object "QuestionGroup".DBCC results for 'sys.ifts_comp_fragment_1630628852_195775'.There are 1948 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_195775".DBCC results for 'SchoolOrInstitution'.There are 232570 rows in 15423 pages for object "SchoolOrInstitution".DBCC results for 'sys.ifts_comp_fragment_1630628852_197520'.There are 1730 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197520".DBCC results for 'sys.ifts_comp_fragment_1630628852_196984'.There are 1593 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196984".DBCC results for 'sys.ifts_comp_fragment_1630628852_196716'.There are 1593 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196716".DBCC results for 'sys.ifts_comp_fragment_1630628852_197790'.There are 1646 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197790".DBCC results for 'sys.ifts_comp_fragment_1630628852_195911'.There are 2298 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_195911".DBCC results for 'Questionnaire'.There are 4 rows in 1 pages for object "Questionnaire".DBCC results for 'sys.ifts_comp_fragment_1630628852_195777'.There are 1717 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195777".DBCC results for 'SecurityCredential'.There are 0 rows in 0 pages for object "SecurityCredential".DBCC results for 'EmailTemplates'.There are 1353 rows in 24 pages for object "EmailTemplates".DBCC results for 'sys.ifts_comp_fragment_1630628852_197925'.There are 1737 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197925".DBCC results for 'sys.ifts_comp_fragment_1630628852_196718'.There are 1638 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196718".DBCC results for 'sys.ifts_comp_fragment_1630628852_196584'.There are 1573 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196584".DBCC results for 'sys.queue_messages_1977058079'.There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".DBCC results for 'QuestionOption'.There are 0 rows in 0 pages for object "QuestionOption".DBCC results for 'sys.ifts_comp_fragment_1630628852_196987'.There are 2494 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_196987".DBCC results for 'LicenseOrCertification'.There are 83680 rows in 220 pages for object "LicenseOrCertification".DBCC results for 'sys.ifts_comp_fragment_1630628852_197525'.There are 2320 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_197525".DBCC results for 'sys.ifts_comp_fragment_1630628852_196183'.There are 2102 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_196183".DBCC results for 'sys.ifts_comp_fragment_1630628852_197928'.There are 1638 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_197928".DBCC results for 'sys.ifts_comp_fragment_1630628852_196586'.There are 1573 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_196586".DBCC results for 'sys.queue_messages_2009058193'.There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".DBCC results for 'sys.ifts_comp_fragment_1630628852_197123'.There are 2909 rows in 19 pages for object "sys.ifts_comp_fragment_1630628852_197123".DBCC results for 'QuestionType'.There are 6 rows in 1 pages for object "QuestionType".DBCC results for 'sys.ifts_comp_fragment_1630628852_196989'.There are 1605 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196989".DBCC results for 'Language'.There are 112622 rows in 1599 pages for object "Language".DBCC results for 'EventSchedule'.There are 0 rows in 0 pages for object "EventSchedule".DBCC results for 'sys.ifts_comp_fragment_1630628852_198198'.There are 2258 rows in 15 pages for object "sys.ifts_comp_fragment_1630628852_198198".DBCC results for 'sys.ifts_comp_fragment_1630628852_197527'.There are 1589 rows in 10 pages for object "sys.ifts_comp_fragment_1630628852_197527".DBCC results for 'sys.ifts_comp_fragment_1630628852_196185'.There are 1850 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196185".DBCC results for 'sys.ifts_comp_fragment_1630628852_197930'.There are 1794 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197930".DBCC results for 'sys.queue_messages_2041058307'.There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".DBCC results for 'sys.ifts_comp_fragment_1630628852_196454'.There are 1754 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196454".DBCC results for 'EmployerOrg'.There are 421583 rows in 3286 pages for object "EmployerOrg".DBCC results for 'sys.ifts_comp_fragment_1630628852_196723'.There are 1657 rows in 11 pages for object "sys.ifts_comp_fragment_1630628852_196723".DBCC results for 'sys.ifts_comp_fragment_1630628852_198200'.There are 2109 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_198200".DBCC results for 'sys.ifts_comp_fragment_1630628852_197529'.There are 1803 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_197529".DBCC results for 'DocumentStore'.There are 162789 rows in 4492 pages for object "DocumentStore".DBCC results for 'sys.ifts_comp_fragment_1630628852_197932'.There are 2362 rows in 16 pages for object "sys.ifts_comp_fragment_1630628852_197932".DBCC results for 'sys.ifts_comp_fragment_1630628852_195919'.There are 2661 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_195919".DBCC results for 'sys.ifts_comp_fragment_1630628852_196456'.There are 2024 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196456".DBCC results for 'sys.ifts_comp_fragment_1630628852_195785'.There are 1894 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_195785".DBCC results for 'Achievement'.There are 193406 rows in 5628 pages for object "Achievement".DBCC results for 'sys.ifts_comp_fragment_1630628852_92035'.There are 642186 rows in 23997 pages for object "sys.ifts_comp_fragment_1630628852_92035".DBCC results for 'sys.ifts_comp_fragment_1630628852_197128'.There are 17650 rows in 141 pages for object "sys.ifts_comp_fragment_1630628852_197128".DBCC results for 'sys.ifts_comp_fragment_1630628852_198202'.There are 2015 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_198202".DBCC results for 'sys.ifts_comp_fragment_1630628852_197531'.There are 2705 rows in 18 pages for object "sys.ifts_comp_fragment_1630628852_197531".DBCC results for 'sys.ifts_comp_fragment_1630628852_195921'.There are 2202 rows in 14 pages for object "sys.ifts_comp_fragment_1630628852_195921".DBCC results for 'sys.ifts_comp_fragment_1630628852_196995'.There are 1905 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196995".DBCC results for 'Competency'.There are 2119893 rows in 65935 pages for object "Competency".DBCC results for 'sys.ifts_comp_fragment_1630628852_196727'.There are 1851 rows in 12 pages for object "sys.ifts_comp_fragment_1630628852_196727".DBCC results for 'sys.ifts_comp_fragment_1630628852_196459'.There are 1961 rows in 13 pages for object "sys.ifts_comp_fragment_1630628852_196459".CHECKDB found 0 allocation errors and 96 consistency errors in database 'VF'.CHECKDB fixed 0 allocation errors and 73 consistency errors in database 'VF'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (VF, repair_allow_data_loss).DBCC execution completed. If DBCC printed error messages, contact your system administrator.---------------------------------------------------------------------------------------------------[b] DBCC CheckDB ('VF') WITH NO_INFOMSGS, ALL_ERRORMSGS - after repair_allow_data_loss [/b]--------------------------------------------------------------------------------------------------Command(s) completed successfully.Kind regardsMitesh Mon, 08 Apr 2013 04:26:12 GMTMitesh Chauhanhttp://www.sqlservercentral.com/Forums/Topic1432970-2893-1.aspxWe have corruption in our database since we upgraded our SQL in the last 3 weeks. I have run DBCC CHECKDB in SSMS and have returned error messages. I have seen this article http://www.sqlservercentral.com/articles/Corruption/65804/ on this website and am just wondering what approach I should take in repairing/fixing/etc.I was told by someone at the software company that our database uses I have three choices right now and I would like to at least try to fix this ourselves. My three choices right now are:1. Run DBCC CHECKBD and allow data loss.2. Contact Microsoft to see if they can help me. If MS can't help they will send me to a data recovery company.3. I can use the software companies tech support (who may still not be able to help me).Hopefully one of you can point me in the correct direction. I really want to get this fixed before we are unable to process at all.Tue, 19 Mar 2013 19:16:39 GMTwendihttp://www.sqlservercentral.com/Forums/Topic1429835-2893-1.aspxTable error: table 'Items' (ID 1954106002). Data row does not have a matching index row in the index 'IX_Advertise_BrandCopy_Price_Stock' (ID 69). Possible missing or invalid keys for the index row matching:Msg 8955, Level 16, State 1, Line 1Data row (1:11226494:9) identified by (Id = 11078215) with index values 'AdvertiseFlag = 1 and BrandCopyParentId = 0 and NSFPPrice = 137.50 and NSFPQtyInStock = 0 and Id = 11078215'.Msg 8951, Level 16, State 1, Line 1Table error: table 'Items' (ID 1954106002). Data row does not have a matching index row in the index 'IX_ITEMS_ADVFLAG_PARETN_PRICE_STOCK' (ID 70). Possible missing or invalid keys for the index row matching:Msg 8955, Level 16, State 1, Line 1Data row (1:10834009:15) identified by (Id = 8885719) with index values 'AdvertiseFlag = 1 and BrandCopyParentId = 0 and NSFPPrice = 9.30 and NSFPQtyInStock = 0 and Id = 8885719'.These indexes were created days ago and are rarely used. Is it safe to drop and recreate corrupted indexes?Tue, 12 Mar 2013 08:06:56 GMTauratohttp://www.sqlservercentral.com/Forums/Topic1430533-2893-1.aspxInitial entry in the SQL Error Log:Error: 5180, Severity: 22, State: 1.Could not open File Control Bank (FCB) for invalid file ID 2816 in database 'WSS_Content_FirmMySites'. Verify the file location. Execute DBCC CHECKDB.So, run DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGSComplete, unedited results:Msg 7987, Level 16, State 1, Line 1System table pre-checks: Object ID 3 has chain linkage mismatch. (1:223355)->next = (1:223357), but (1:223357)->prev = (1:223356). Check statement terminated due to unrepairable error.Try DBCC CHECKALLOCMsg 7987, Level 16, State 1, Line 1System table pre-checks: Object ID 3 has chain linkage mismatch. (1:223355)->next = (1:223357), but (1:223357)->prev = (1:223356). Check statement terminated due to unrepairable error.This is a new client, so see when DBCC CHECKDB was last successfully run via DBCC PAGE(dbname, 1,9,3) WITH TABLERESULTS:2011-10-31 01:10:06.737Check the previous backup in a parallel database: same errors as above.Backups older than this have already been deleted.This database is part of a sharepoint instance.DBCC CHECKDB did generate a stack dump.Is there anyway to fix this corruption?Wed, 13 Mar 2013 10:57:02 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic1426147-2893-1.aspxHi,Database backup failed due to server four HD failure and RAID 5 configuration also OS crashed...not able to reboot the server.. in this case, change the new four HD and install fresh OS then restored database from last day good backup from Tape.. so 1 day data was lost..I try to restore the failed backup file but it won't allowed ...Checked by VERIFYONLY command as below errors..[code="other"]restore verifyonly from disk = 'D:\emsevent\emsevents_backup_2013_03_02_000002_3310132.bak' with checksumMsg 3189, Level 16, State 1, Line 3Damage to the backup set was detected.Msg 3013, Level 16, State 1, Line 3VERIFY DATABASE is terminating abnormally.[/code]restore by CONTINUE_AFTER_ERROR; this command will not help[code="other"]Processed 528 pages for database 'emsevents', file 'EMSEvents_dat' on file 1.Processed 0 pages for database 'emsevents', file 'EMSEventsIndex_dat' on file 1.Processed 16 pages for database 'emsevents', file 'EMSTimeAndLocalTimeIdx_dat' on file 1.Processed 16 pages for database 'emsevents', file 'EMSLocalDateAndTimeIdx_dat' on file 1.Processed 16 pages for database 'emsevents', file 'EMSLocalDateAndTimeAndLocalTimeIdx_dat' on file 1.Processed 2 pages for database 'emsevents', file 'EMSEvents_log' on file 1.Msg 3283, Level 16, State 1, Line 1The file "EMSEventsIndex_dat" failed to initialize correctly. Examine the error logs for more details.Msg 3283, Level 16, State 1, Line 1The file "EMSTimeAndLocalTimeIdx_dat" failed to initialize correctly. Examine the error logs for more details.Msg 3283, Level 16, State 1, Line 1The file "EMSLocalDateAndTimeIdx_dat" failed to initialize correctly. Examine the error logs for more details.Msg 3283, Level 16, State 1, Line 1The file "EMSLocalDateAndTimeAndLocalTimeIdx_dat" failed to initialize correctly. Examine the error logs for more details.Msg 3283, Level 16, State 1, Line 1The file "EMSEvents_log" failed to initialize correctly. Examine the error logs for more details.The database cannot be recovered because the log was not restored.This RESTORE statement successfully performed some actions, but the database could not be brought online because one or more RESTORE steps are needed. Previous messages indicate reasons why recovery cannot occur at this point.Damage to the backup set was detected.RESTORE WITH CONTINUE_AFTER_ERROR was successful but some damage was encountered. Inconsistencies in the database are possible.RESTORE DATABASE successfully processed 578 pages in 0.479 seconds (9.427 MB/sec).Error log MessageRESTORE detected an error on page (16640:1409297664) in database "emsevents" as read from the backup set.[/code]If any alternative ways how to resolved failed backup set?thanksanandaMon, 04 Mar 2013 02:53:57 GMTananda.murugesanhttp://www.sqlservercentral.com/Forums/Topic1382538-2893-1.aspxHi Experts,Getting below error when tried to recover db from suspect mode..dbcc checkdb didnt give any error but when tried to make it online give thisThe log scan number (256603:182:1) passed to log scan in database 'PRD_dis not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.Msg 3414, Level 21, State 1, Line 1An error occurred during recovery, preventing the database 'PRD_d(database ID 6) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.Thu, 08 Nov 2012 08:48:22 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1425436-2893-1.aspxHi friends can any provide me with diaster recovey or business continuity document. i have to do one for my client.. but i dont know how to do that one.. what are the questions that i should ask to get information from clientwhere to start and how to prepare documentation.Fri, 01 Mar 2013 04:39:43 GMTm.rajesh.ukhttp://www.sqlservercentral.com/Forums/Topic1419413-2893-1.aspxDatabase taking long to bring online in 1hr 15 minutes.Is this normal.I am SQL Server.Wed, 13 Feb 2013 05:05:00 GMTkapfundestanleyhttp://www.sqlservercentral.com/Forums/Topic1419466-2893-1.aspxWe have nightly backups configured for the Team Foundation Server TFS databases. Recently, the transaction log backup for the TFS_Warehouse database is failing with the following message:'Backup detected log corruption in database Tfs_Warehouse'We are doing a backup of the database and the transaction log for this database. The backup seems to complete successfully and a .bak file is created. A .trn file is not created however.My question is How can the transaction log be repaired without getting the database out of sync from the other TFS databases or losing data?The corruption occurred a week ago and there has been TFS checkins and data committed to the Tfs_Warehouse database since the corruption occurred. We keep backups for 14 days but if we go back pre-corruption, the last time the transaction log .trn backup succeeded, we would lose all data since.What would be the best approach here?Thanks in advance for any suggestionsWed, 13 Feb 2013 06:21:57 GMTdlq1211http://www.sqlservercentral.com/Forums/Topic1416290-2893-1.aspxRunning on Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) I ran DBCC CHECKDB (CHRUSAPP) WITH NO_INFOMSGS, ALL_ERRORMSGSwhich returned the following results:Msg 8935, Level 16, State 1, Line 1Table error: Object ID 1102783136, index ID 1, partition ID 72057594172211200, alloc unit ID 72057594174046208 (type In-row data).The previous link (1:15001) on page (1:13954) does not match the previous page (1:4080) that the parent (1:28791), slot 35 expects for this page.Msg 8936, Level 16, State 1, Line 1Table error: Object ID 1102783136, index ID 1, partition ID 72057594172211200, alloc unit ID 72057594174046208 (type In-row data). B-tree chain linkage mismatch. (1:4080)->next = (1:13954), but (1:13954)->Prev = (1:15001).CHECKDB found 0 allocation errors and 2 consistency errors in table 'PJRATE' (object ID 1102783136).CHECKDB found 0 allocation errors and 2 consistency errors in database 'CHRUSAPP'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (CHRUSAPP).SQL Server Management Studio.Management.Maintenance Plans shows same error since 1/9/2013.I checked for duplicate keys and didn't find any. Would a DBCC DBREINDEX('PJRATE') likely correct the error? BTW, PJRATE is a master table with 3,722 rows. We could delete all data through the application UI and then copy/paste or import, again through the UI, if we had to.Are these errors indicative of hard disk failures?Thanks in advance.Wed, 06 Feb 2013 00:55:16 GMTbill-900846http://www.sqlservercentral.com/Forums/Topic1415834-2893-1.aspxHi AllAfter doing some Research & Testing on corruption, I have a question.>> Database is corrupt>> Determined that it's the transaction log that is corrupt. Confirmed this by checking the error log and found "SQL Server detected a logical consistency-based I/O error: incorrect checksum............................ldf"I am well aware that detaching a corrupt database is not a good thing. If I know that SQL was shutdown cleanly - Is it then semi-ok to detach the database and then re-attach with attach_rebuild_log ?Thoughts?Tue, 05 Feb 2013 07:30:42 GMTSQLSACThttp://www.sqlservercentral.com/Forums/Topic1413532-2893-1.aspxone of my database's tran log got full on dev server . (recovery doesnt matter)here are the detailstotal drive : 180 gblog file on same drive : 28gbdata file on same drive : 68 gb free space : 84gbwhat i did : 1) try to take log backup with backup log testdb to disk = 'nul' .. ran to 30 minutes . i stopped it when i see it was getting blocked by some internal prcesses (spid < 50)2) then tried Dbcc shrinkdatabase ('testdb') .. same blocking happened .. i stopped it 3) tried to take database offline (so that log file can be removed by attach .detach and remove log file)btu again query got blocked by internale porceess . Any help ? Wed, 30 Jan 2013 02:39:18 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1412855-2893-1.aspxHi guys,I know how important it is to run dbcc checks regularly, and to run it hassle free. I am actually trying to find out a script which can automate this task for me, and send me the reports for all the checks through mail. I need the dbcc checkdb output only if there is any errors after running consistency checks, and wouldn't really bother to get an e-mail if there is none. I also want to get a mail from all the linked servers that have been configured in my environment so that it gives me a complete list of only the error output from dbcc checkdb ignoring other messages, wherein I can quickly login to that server and rectify the things as per guidelines laid by Paul for various dbcc errors.I hope if somebody could point me out to some links or at best can provide me a script to do this, in case if they have implemented what I am looking for.Thanks,FaisalTue, 29 Jan 2013 03:13:54 GMTfaisalfarouqihttp://www.sqlservercentral.com/Forums/Topic1407356-2893-1.aspxOur weekly integrity check job on one of our servers has now failed two weeks in a row. In both cases, the only database known to be generating an error is the 'master' db.If I run the DBCC CHECKDB('master') command manually, I get the same results. The log shows no errors, and that the DB is A-OK. The output to the console of the command indicates the same. However, instead of the final line about errors reported by DBCC (as you see here, when I run the command against msdb):[code="plain"]CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.[/code]I get Msg 0:[code="plain"]CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.Msg 0, Level 11, State 0, Line 0A severe error occurred on the current command. The results, if any, should be discarded.[/code]Naturally, as it appears the results that should be discarded are the ones that say the DB is fine, I'm in a bit of a quandary.The database has not been restarted since I first saw the error; I'll be requesting one today.The databases on the server all seem to be behaving normally.Our external DBA team has recommended updating the server (SQL 2008, SP2, version 10.00.4279) to SP2 cumulative update 7, as that is supposed to fix a situation where you get this message running DBCC CHECKDB on a DB/table with a spatial index. While I don't mind updating (I'd actually have them go to SP3, CU3), this looks like a "hail Mary" play to me.So:1. Is it likely that I actually have a corrupt DB?2. Noting that we'd install the CU on two other servers that have no symptoms before we'd get to the production box that does - does it seem at all likely that SP2CU7 (or SP3CU3) will actually fix the problem?3. Is there something else I should be looking at/checking on?Thanks in advance for your advice.Tue, 15 Jan 2013 10:06:35 GMTRD Francishttp://www.sqlservercentral.com/Forums/Topic1410484-2893-1.aspxHi,Has anyone got any experience of recovering the master.mdf/ldf files from a Symantec Backup Exec $4idr file? I've attempted to follow their procedure TECH31277 ([url=http://www.symantec.com/docs/TECH31277 ]http://www.symantec.com/docs/TECH31277 [/url]) and get the following error message:2013-01-23 10:23:40.63 Server Error: 3411, Severity: 21, State: 1.2013-01-23 10:23:40.63 Server Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall.This implies that the newly restored and recovered master file is invalid. So either it wasn't backed up correctly or it wasn't restored completely.If anyone does have first hand experience of using this method to recover a master file then I'd be keen to hear your verdict as to whether this works and how you did it.Thanks,MikeWed, 23 Jan 2013 05:02:56 GMTmike.dinnishttp://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspx--Error Number 824DESCRIPTION: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:845407; actual 1:607839). It occurred during a read of page (1:845407) in database ID 46 at offset 0x0000019ccbe000 in file ‘xx.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.--If run this , I am getting below specified error message DBCC CHECKDB ('DBname') WITH NO_INFOMSGS, ALL_ERRORMSGS--Error message:Msg 8946, Level 16, State 12, Line 1Table error: Allocation page (1:145584) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.Msg 8921, Level 16, State 1, Line 1Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.Msg 8998, Level 16, State 2, Line 1Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 6 pages from (1:145584) to (1:153671). 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 72057594050707456 (type Unknown), page (1:145584). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 62916617 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page (1:145584). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 62916617 and -4.Can you suggest me to resolve this please….Can you please let me know if you need any other details….Thank you in Advance…..KrishnaWed, 02 Jan 2013 04:04:59 GMTkrishnaprasad14http://www.sqlservercentral.com/Forums/Topic1405038-2893-1.aspxHi,I initially took backup from SQL Server 2012 (database compatibility mode was set to SQL Server 2008 (100)) but when I try to restore that backup on SQL Server 2008 R2 it is giving me error as "Specified cast is not valid".I would appreciate if anyone can help me or if there is any alternate solution to backup from SQL Server 2012 and successfully restore it on SQL Server 2008 R2, please let me know.Thank you.Wed, 09 Jan 2013 15:10:52 GMTmonilpshttp://www.sqlservercentral.com/Forums/Topic1401804-2893-1.aspxExecuted as user: LAVOISIER\SQLAGENTACCOUNT. ...600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 2:00:00 PM Progress: 2012-12-30 14:00:00.68 Source: {4090B986-66AE-4E33-9706-E39A5B76F0D3} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2012-12-30 14:00:01.52 Source: Check Database Integrity Executing query "USE [SLine2] ".: 50% complete End Progress Error: 2012-12-30 14:06:14.63 Code: 0xC002F210 Source: Check Database Integrity Execute SQL Task Description: Executing the query "DBCC CHECKDB(N'SLine2') WITH NO_INFOMSGS " failed with the following error: "Table error: table 'doc' (ID 142623551). Data row does not have a matching index row in the index 'IN_DOC_DTREAL' (ID 11). Possible missing or invalid keys for the index row matching: Data row (1:1607299:17) identified by (id_doc = 77728405.) with index values 'cd_cliente = 'HFA ' and dt_doc_real = '2012-10-29 08:25:00.000' and id_doc = 77728405.'. Table error: table 'doc' (ID 142623551). Index row in index 'IN_DOC_DTREAL' (ID 11) does not match any data row. Possible extra or invalid keys for: Index row (1:1608079:40) with values (cd_cliente = 'HFA ' and dt_doc_real = '2012-10-29 09:36:00.000' and id_doc = 77728405.) pointing to the data row identified by (id_doc = 77728405.). CHECKDB found 0 allocation errors and 2 consistency errors in table 'doc' (object ID 142623551). CHECKDB found 0 allocation errors and 2 consistency errors in database 'SLine2'. repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (SLine2).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End ErrorThe id_doc is unique How to solve this error ?Wed, 02 Jan 2013 06:18:54 GMTmvargas109http://www.sqlservercentral.com/Forums/Topic1399047-2893-1.aspxGuys:Some how an invalid or corrupt data ended up in the system. Presumably this happened when the database was upgraded from a legacy system. I know that in the old systems a bulk load process would allow bad dates to come in. It was a bug that was ignored by the dev team. I am trying to identify the rows in order to identify/correct the data but am having absolutely NO luck. I cant convert it nor does the isdate function work without error'ing out. Any suggestions? I am out of options.Thanks!Thu, 20 Dec 2012 10:15:29 GMTDavid Paskiethttp://www.sqlservercentral.com/Forums/Topic1397709-2893-1.aspxHi,Backup failed as below error messages, after that verify DBCC CHECKDB <DBNAME> WITH DATA_PURITY.Failed:(-1073548784) Executing the query "BACKUP DATABASE [BaseComponents] TO DISK = N'E:\\S..." failed with the following error: "Read on "D:\\Data\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\DATA\\BaseComponents.mdf" failed: 23(Data error (cyclic redundancy check).)BACKUP DATABASE is terminating abnormally.Please provide the solution for the database consistancy errorError mesages[code="sql"] DBCC results for 'BaseComponents'.Service Broker Msg 9675, State 1: Message Types analyzed: 14.Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.Service Broker Msg 9667, State 1: Services analyzed: 3.Service Broker Msg 9668, State 1: Service Queues analyzed: 3.Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.Msg 8966, Level 16, State 2, Line 1Unable to read and latch page (1:542654) with latch type SH. 23(Data error (cyclic redundancy check).) failed.Msg 8966, Level 16, State 2, Line 1Unable to read and latch page (1:542686) with latch type SH. 23(Data error (cyclic redundancy check).) failed.CHECKDB found 0 allocation errors and 2 consistency errors not associated with any single object.DBCC results for 'sys.sysrscols'.There are 1353 rows in 15 pages for object "sys.sysrscols".DBCC results for 'sys.sysrowsets'.There are 233 rows in 2 pages for object "sys.sysrowsets".DBCC results for 'sys.sysallocunits'.There are 261 rows in 4 pages for object "sys.sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.syspriorities'.There are 0 rows in 0 pages for object "sys.syspriorities".DBCC results for 'sys.sysfgfrag'.There are 2 rows in 1 pages for object "sys.sysfgfrag".DBCC results for 'sys.sysphfg'.There are 1 rows in 1 pages for object "sys.sysphfg".DBCC results for 'sys.sysprufiles'.There are 2 rows in 1 pages for object "sys.sysprufiles".DBCC results for 'sys.sysftinds'.There are 3 rows in 1 pages for object "sys.sysftinds".DBCC results for 'sys.sysowners'.There are 15 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysprivs'.There are 134 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.There are 504 rows in 9 pages for object "sys.sysschobjs".DBCC results for 'sys.syscolpars'.There are 1810 rows in 41 pages for object "sys.syscolpars".DBCC results for 'sys.sysnsobjs'.There are 1 rows in 1 pages for object "sys.sysnsobjs".DBCC results for 'sys.syscerts'.There are 0 rows in 0 pages for object "sys.syscerts".DBCC results for 'sys.sysxprops'.There are 0 rows in 0 pages for object "sys.sysxprops".DBCC results for 'sys.sysscalartypes'.There are 34 rows in 1 pages for object "sys.sysscalartypes".DBCC results for 'sys.systypedsubobjs'.There are 0 rows in 0 pages for object "sys.systypedsubobjs".DBCC results for 'sys.sysidxstats'.There are 439 rows in 7 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 605 rows in 4 pages for object "sys.sysiscols".DBCC results for 'sys.sysbinobjs'.There are 23 rows in 1 pages for object "sys.sysbinobjs".DBCC results for 'sys.sysaudacts'.There are 0 rows in 0 pages for object "sys.sysaudacts".DBCC results for 'sys.sysobjvalues'.There are 636 rows in 197 pages for object "sys.sysobjvalues".DBCC results for 'sys.sysclsobjs'.There are 17 rows in 1 pages for object "sys.sysclsobjs".DBCC results for 'sys.sysrowsetrefs'.There are 0 rows in 0 pages for object "sys.sysrowsetrefs".DBCC results for 'sys.sysremsvcbinds'.There are 0 rows in 0 pages for object "sys.sysremsvcbinds".DBCC results for 'sys.sysxmitqueue'.There are 0 rows in 0 pages for object "sys.sysxmitqueue".DBCC results for 'sys.sysrts'.There are 1 rows in 1 pages for object "sys.sysrts".DBCC results for 'sys.sysconvgroup'.There are 0 rows in 0 pages for object "sys.sysconvgroup".DBCC results for 'sys.sysdesend'.There are 0 rows in 0 pages for object "sys.sysdesend".DBCC results for 'sys.sysdercv'.There are 0 rows in 0 pages for object "sys.sysdercv".DBCC results for 'sys.syssingleobjrefs'.There are 363 rows in 4 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 1532 rows in 13 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysguidrefs'.There are 0 rows in 0 pages for object "sys.sysguidrefs".DBCC results for 'sys.syscompfragments'.There are 0 rows in 0 pages for object "sys.syscompfragments".DBCC results for 'sys.sysftstops'.There are 0 rows in 0 pages for object "sys.sysftstops".DBCC results for 'sys.sysqnames'.There are 97 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 99 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 112 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 18 rows in 1 pages for object "sys.sysxmlplacement".DBCC results for 'sys.sysobjkeycrypts'.There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".DBCC results for 'sys.sysasymkeys'.There are 0 rows in 0 pages for object "sys.sysasymkeys".DBCC results for 'sys.syssqlguides'.There are 0 rows in 0 pages for object "sys.syssqlguides".DBCC results for 'sys.sysbinsubobjs'.There are 3 rows in 1 pages for object "sys.sysbinsubobjs".DBCC results for 'sys.syssoftobjrefs'.There are 360 rows in 5 pages for object "sys.syssoftobjrefs".DBCC results for 'TableCellDataItem'.There are 0 rows in 0 pages for object "TableCellDataItem".DBCC results for 'BC_Lookup'.There are 34 rows in 1 pages for object "BC_Lookup".DBCC results for 'TableCellRowLocation'.There are 0 rows in 0 pages for object "TableCellRowLocation".DBCC results for 'TableCellType'.There are 6 rows in 1 pages for object "TableCellType".DBCC results for 'BC_ConfigInstance'.There are 186 rows in 7 pages for object "BC_ConfigInstance".DBCC results for 'TableColumn'.There are 0 rows in 0 pages for object "TableColumn".DBCC results for 'TableDataItem'.There are 0 rows in 0 pages for object "TableDataItem".DBCC results for 'TableDesign'.There are 0 rows in 0 pages for object "TableDesign".DBCC results for 'BC_ConfigItem'.There are 67 rows in 2 pages for object "BC_ConfigItem".DBCC results for 'TableDynamicVisualization'.There are 0 rows in 0 pages for object "TableDynamicVisualization".DBCC results for 'TableRow'.There are 0 rows in 0 pages for object "TableRow".DBCC results for 'BC_ConfigSchema'.There are 49 rows in 2 pages for object "BC_ConfigSchema".DBCC results for 'TableTimeSeriesDataItem'.There are 0 rows in 0 pages for object "TableTimeSeriesDataItem".DBCC results for 'TableView'.There are 0 rows in 0 pages for object "TableView".DBCC results for 'BC_Owner'.There are 24 rows in 1 pages for object "BC_Owner".DBCC results for 'BC_DataVersionInfo'.There are 9 rows in 1 pages for object "BC_DataVersionInfo".DBCC results for 'BC_ApplicationAudit'.There are 0 rows in 0 pages for object "BC_ApplicationAudit".DBCC results for 'BC_ApplicationAuditHistory'.There are 0 rows in 0 pages for object "BC_ApplicationAuditHistory".DBCC results for 'BC_UserDetails'.There are 0 rows in 0 pages for object "BC_UserDetails".DBCC results for 'BC_AuditSummary'.There are 0 rows in 0 pages for object "BC_AuditSummary".DBCC results for 'EXECUTEDINFO'.There are 62 rows in 5 pages for object "EXECUTEDINFO".DBCC results for 'EXECUTION'.There are 33618 rows in 811 pages for object "EXECUTION".DBCC results for 'JOB'.There are 33 rows in 4 pages for object "JOB".DBCC results for 'RECURRENCE'.There are 33 rows in 4 pages for object "RECURRENCE".DBCC results for 'HOLIDAYS'.There are 0 rows in 0 pages for object "HOLIDAYS".DBCC results for 'WEEKENDS'.There are 0 rows in 0 pages for object "WEEKENDS".DBCC results for 'EXPLORER_PRIVATE_GROUPS'.There are 0 rows in 0 pages for object "EXPLORER_PRIVATE_GROUPS".DBCC results for 'EXPLORER_PRIVATE_ITEMS'.There are 0 rows in 0 pages for object "EXPLORER_PRIVATE_ITEMS".DBCC results for 'EXPLORER_PUBLIC_GROUPS'.There are 0 rows in 0 pages for object "EXPLORER_PUBLIC_GROUPS".DBCC results for 'EXPLORER_PUBLIC_ITEMS'.There are 0 rows in 0 pages for object "EXPLORER_PUBLIC_ITEMS".DBCC results for 'BC_Printers'.There are 2 rows in 1 pages for object "BC_Printers".DBCC results for 'BC_ScheduleData'.There are 3 rows in 1 pages for object "BC_ScheduleData".DBCC results for 'ICO_Icon'.There are 18 rows in 1 pages for object "ICO_Icon".DBCC results for 'MSD_Master_Search_Datasource'.There are 5 rows in 1 pages for object "MSD_Master_Search_Datasource".DBCC results for 'NAB_Navigation_Building'.There are 0 rows in 0 pages for object "NAB_Navigation_Building".DBCC results for 'NAR_Navigation_Area'.There are 0 rows in 0 pages for object "NAR_Navigation_Area".DBCC results for 'NAS_Navigation_Site'.There are 0 rows in 0 pages for object "NAS_Navigation_Site".DBCC results for 'BC_ArchiveJobs'.There are 1 rows in 1 pages for object "BC_ArchiveJobs".DBCC results for 'NCA_Navigation_Categories'.There are 0 rows in 0 pages for object "NCA_Navigation_Categories".DBCC results for 'NML_NAS_MSD_Link'.There are 0 rows in 0 pages for object "NML_NAS_MSD_Link".DBCC results for 'SCU_Supported_Culture'.There are 1 rows in 1 pages for object "SCU_Supported_Culture".DBCC results for 'STL_String_Lookup'.There are 10 rows in 1 pages for object "STL_String_Lookup".DBCC results for 'UET_User_EasyTrack'.There are 0 rows in 0 pages for object "UET_User_EasyTrack".DBCC results for 'BC_ShiftSummaryInfo'.Msg 8929, Level 16, State 1, Line 1Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29856104448 owned by data record identified by RID = (1:541810:40)Msg 8929, Level 16, State 1, Line 1Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29856759808 owned by data record identified by RID = (1:541810:50)Msg 8929, Level 16, State 1, Line 1Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29854859264 owned by data record identified by RID = (1:541811:31)Msg 8929, Level 16, State 1, Line 1Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 30184964096 owned by data record identified by RID = (1:551711:43)Msg 2533, Level 16, State 1, Line 1Table error: page (1:542654) allocated to object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.Msg 8965, Level 16, State 1, Line 1Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 0, text ID 29854859264 is referenced by page (1:531974), slot 4, but was not seen in the scan.Msg 8965, Level 16, State 1, Line 1Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 1, text ID 29856759808 is referenced by page (1:531982), slot 2, but was not seen in the scan.Msg 8965, Level 16, State 1, Line 1Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 2, text ID 30184964096 is referenced by page (1:551711), slot 43, but was not seen in the scan.Msg 2533, Level 16, State 1, Line 1Table error: page (1:542686) allocated to object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.Msg 8965, Level 16, State 1, Line 1Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542686), slot 0, text ID 29856104448 is referenced by page (1:531822), slot 9, but was not seen in the scan.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:553670), slot 18, text ID 30184964096 is not referenced.There are 310724 rows in 2785 pages for object "BC_ShiftSummaryInfo".CHECKDB found 0 allocation errors and 11 consistency errors in table 'BC_ShiftSummaryInfo' (object ID 990626572).DBCC results for 'UPR_User_Preferences'.There are 0 rows in 0 pages for object "UPR_User_Preferences".DBCC results for 'sys.fulltext_index_docidmap_2126630619'.There are 0 rows in 0 pages for object "sys.fulltext_index_docidmap_2126630619".DBCC results for 'sys.fulltext_index_docidstatus_2126630619'.There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_2126630619".DBCC results for 'BC_AttributeDefinition'.There are 72 rows in 2 pages for object "BC_AttributeDefinition".DBCC results for 'sys.fulltext_docidfilter_2126630619'.There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_2126630619".DBCC results for 'BC_Container'.There are 84 rows in 4 pages for object "BC_Container".DBCC results for 'sys.fulltext_indexeddocid_2126630619'.There are 0 rows in 0 pages for object "sys.fulltext_indexeddocid_2126630619".DBCC results for 'BC_ContainerAttribute'.There are 0 rows in 0 pages for object "BC_ContainerAttribute".DBCC results for 'sys.fulltext_avdl_2126630619'.There are 1 rows in 1 pages for object "sys.fulltext_avdl_2126630619".DBCC results for 'BC_ContainerGroup'.There are 198 rows in 2 pages for object "BC_ContainerGroup".DBCC results for 'sys.fulltext_index_docidmap_91147370'.There are 0 rows in 0 pages for object "sys.fulltext_index_docidmap_91147370".DBCC results for 'BC_ContainerRole'.There are 0 rows in 0 pages for object "BC_ContainerRole".DBCC results for 'sys.fulltext_index_docidstatus_91147370'.There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_91147370".DBCC results for 'BC_ShiftSummary'.There are 16493 rows in 1139 pages for object "BC_ShiftSummary".DBCC results for 'sys.fulltext_docidfilter_91147370'.There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_91147370".DBCC results for 'sys.fulltext_indexeddocid_91147370'.There are 0 rows in 0 pages for object "sys.fulltext_indexeddocid_91147370".DBCC results for 'BC_Display'.There are 867 rows in 72 pages for object "BC_Display".DBCC results for 'sys.fulltext_avdl_91147370'.There are 1 rows in 1 pages for object "sys.fulltext_avdl_91147370".DBCC results for 'BC_DisplayAttribute'.There are 10278 rows in 145 pages for object "BC_DisplayAttribute".DBCC results for 'sys.fulltext_index_docidmap_155147598'.There are 0 rows in 0 pages for object "sys.fulltext_index_docidmap_155147598".DBCC results for 'BC_DisplayRole'.There are 0 rows in 0 pages for object "BC_DisplayRole".DBCC results for 'sys.fulltext_index_docidstatus_155147598'.There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_155147598".DBCC results for 'BC_Group'.There are 250 rows in 8 pages for object "BC_Group".DBCC results for 'sys.fulltext_docidfilter_155147598'.There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_155147598".DBCC results for 'BC_GroupRole'.There are 0 rows in 0 pages for object "BC_GroupRole".DBCC results for 'sys.fulltext_indexeddocid_155147598'.There are 0 rows in 0 pages for object "sys.fulltext_indexeddocid_155147598".DBCC results for 'BC_GroupAttribute'.There are 0 rows in 0 pages for object "BC_GroupAttribute".DBCC results for 'sys.fulltext_avdl_155147598'.There are 1 rows in 1 pages for object "sys.fulltext_avdl_155147598".DBCC results for 'BC_GroupDisplay'.There are 2678 rows in 20 pages for object "BC_GroupDisplay".DBCC results for 'BC_SecurityRole'.There are 0 rows in 0 pages for object "BC_SecurityRole".DBCC results for 'UdqProperties'.There are 1 rows in 1 pages for object "UdqProperties".DBCC results for 'UdqQueries'.There are 4 rows in 1 pages for object "UdqQueries".DBCC results for 'UdqQueryInfo'.There are 8 rows in 3 pages for object "UdqQueryInfo".DBCC results for 'UdqQueryParameters'.There are 14 rows in 1 pages for object "UdqQueryParameters".DBCC results for 'WorkcenterProperties'.There are 1 rows in 1 pages for object "WorkcenterProperties".DBCC results for 'EnumerationDataSources'.There are 0 rows in 0 pages for object "EnumerationDataSources".DBCC results for 'EnumerationMapping'.There are 0 rows in 0 pages for object "EnumerationMapping".DBCC results for 'EnumerationStates'.There are 0 rows in 0 pages for object "EnumerationStates".DBCC results for 'Enumerations'.There are 0 rows in 0 pages for object "Enumerations".DBCC results for 'EnumerationBulkLoadCommands'.There are 0 rows in 0 pages for object "EnumerationBulkLoadCommands".DBCC results for 'EnumerationBulkLoadErrors'.There are 0 rows in 0 pages for object "EnumerationBulkLoadErrors".DBCC results for 'EnumerationChanges'.There are 0 rows in 0 pages for object "EnumerationChanges".DBCC results for 'IntervalDefinitions'.There are 7 rows in 1 pages for object "IntervalDefinitions".DBCC results for 'DUAL'.There are 1 rows in 1 pages for object "DUAL".DBCC results for 'BC_SSTableEntry'.There are 606 rows in 356 pages for object "BC_SSTableEntry".DBCC results for 'TempRawEnumMappings'.There are 0 rows in 0 pages for object "TempRawEnumMappings".DBCC results for 'TempRawEnumTypes'.There are 0 rows in 0 pages for object "TempRawEnumTypes".DBCC results for 'sys.queue_messages_1977058079'.There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".DBCC results for 'sys.queue_messages_2009058193'.There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".DBCC results for 'sys.queue_messages_2041058307'.There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".DBCC results for 'sys.filestream_tombstone_2073058421'.There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".DBCC results for 'sys.syscommittab'.There are 0 rows in 0 pages for object "sys.syscommittab".DBCC results for 'TableAlphanumericDataItem'.There are 0 rows in 0 pages for object "TableAlphanumericDataItem".DBCC results for 'IP_EQ'.There are 5147 rows in 49 pages for object "IP_EQ".DBCC results for 'BC_Package'.There are 11 rows in 1 pages for object "BC_Package".DBCC results for 'TableBreakpoint'.There are 0 rows in 0 pages for object "TableBreakpoint".DBCC results for 'OM_EQUIP_LINKS'.There are 25620 rows in 194 pages for object "OM_EQUIP_LINKS".DBCC results for 'TableCell'.There are 0 rows in 0 pages for object "TableCell".DBCC results for 'BC_LookupType'.There are 8 rows in 1 pages for object "BC_LookupType".DBCC results for 'TableCellColumnLocation'.There are 0 rows in 0 pages for object "TableCellColumnLocation".CHECKDB found 0 allocation errors and 13 consistency errors in database 'BaseComponents'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (BaseComponents).DBCC execution completed. If DBCC printed error messages, contact your system administrator.[/code]ThanksanandaTue, 18 Dec 2012 05:12:09 GMTananda.murugesanhttp://www.sqlservercentral.com/Forums/Topic1378252-2893-1.aspxThe Master database on one of our servers is showing in SSMS as Single-user mode. I have tried to change it back to multi-user, but am getting error "Option 'MULTI_USER' cannot be set in database 'master'". Weirdly, I am able to connect to the database and make changes to it.Sys.databases is reporting user_access as 'SINGLE_USER'However, sp_helpdb 'master' reports "user_access=MULTI_USER"DBCC CHECKDB returns nothing of interestThe error logs all look fine, too.I understand that another instance of SQL Server was installed on the same server recently, though that is used by another department, and I don't have access to that instance. Could this have caused this confusion?Our infrastructure providers are saying that this inconsistency is only a GUI issue, so we shouldn't be concerned. However, I am concerned that this could be indicative of a wider problem with the database and that they are trying to sweep it under the carpet.Can anyone shed any light on these inconsistencies?ThanksMon, 29 Oct 2012 07:49:02 GMTmister boomhttp://www.sqlservercentral.com/Forums/Topic1390999-2893-1.aspxI have a full backup, I made a mistake with some data and made a transaction log backup so I could restore the db on another server and compare data.Now, I made a mistake can called it something like "dbname 5:30pm.trn", which wasn't caught by SSMS, but created a file "dbname 5", because the colon caused an issue.Once it was done I refreshed the directory and it was 0k in size.It seems that just broke the restore chain entirely and no TL backups after that corrupt file would be of any use. Time to just do another full backup and start the chain fresh?Any advice on what a more experienced DBA would do in this situation? Any way to recover the situation or is it just making the best of the situation at this point?Thu, 29 Nov 2012 21:20:49 GMTShawn Therrienhttp://www.sqlservercentral.com/Forums/Topic1392845-2893-1.aspxHi all,I'm having random issues of poor performance with a DB of 40 Gb.It has more than 1200 tables but when I execute a reindex on a table (named MOV_MAG) with over one million or records, the issues are solved for some time, but they return after few weeks.I don't want to schedule a reindex of that table every day, I would like to find where is the cause of these issues.Some infos of the server:It is a virtual machine Installed on hyper-v serverIt is a dedicated SQL server, no other software are runningThere are 3 dedicated phisical cores for 3 virtual processors.There are 8Gb of reserved ram, 2gb for the system and 6gb for SQL ServerThere are 2 virtual disks drivesThe first drive is 30Gb (20Gb used) dedicated for the system (10gb free) running win2008R2The second drive is 100Gb for the data (60gb used)There is one virtual network adapter 1000Mbits/s and the phisical adapter is fiber optic.The DB Server version is MS SQL 2008.Usually there are 30 users connected.The DB was started twelve years ago and this issue is started one year ago and I'm still trying to find a solution without results. :(Can someone help me please?Thank you in advanceClaudio (from Italy)Wed, 05 Dec 2012 02:08:01 GMTreguittihttp://www.sqlservercentral.com/Forums/Topic1327389-2893-1.aspxMy database tables are missing after a virus infection. How can I repair and recreate missed table from database folder.when attached the .mdf and .ldf file, only dbo.sysdiagrams table is there.how can I retrieve the other tables.please help me in the topic.ThanxTue, 10 Jul 2012 04:09:27 GMTnajeeb_kt2000http://www.sqlservercentral.com/Forums/Topic1326639-2893-1.aspxWe've had corruption in master and msdb on a SQL2008R2 SP1 on Win2k8r2.[code="plain"]Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=12,depid=0,depsubid=0) was found in the system table sys.syssingleobjrefs (class=12).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=13,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=13).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=1,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=13,depid=2,depsubid=0) was found in the system table sys.syssingleobjrefs (class=13).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=2,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=3,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=4,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=5,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=259,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=260,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=261,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=263,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=272,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=26,depid=286,depsubid=0,indepid=3,indepsubid=0) was found in the system table sys.sysmultiobjrefs (class=26).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=100) was found in the system table sys.syssingleobjrefs (class=76).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=101) was found in the system table sys.syssingleobjrefs (class=76).Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3851, State 1: An invalid row (class=76,depid=65536,depsubid=102) was found in the system table sys.syssingleobjrefs (class=76).CHECKDB found 0 allocation errors and 18 consistency errors not associated with any single object.[/code]Error opening errorlog:Exception happened when running extended stored procedure 'xp_readerrorlog' in the library 'xpstar.dll'. SQL Server is terminating process 254. Exception type: Win32 exception; Exception code: 0xc0000006.I'm planning to do a restore of master & msdb in a few hours. I've rebuilt these databases before on a test system, but never restored. What is the recommended approach, rebuild, patch, then restore, or just restore?Will also be patching the OS with [url]http://support.microsoft.com/kb/2708811[/url] NTFS.sys update as recommended by Microsoft support.Sun, 08 Jul 2012 19:15:35 GMTfoxxohttp://www.sqlservercentral.com/Forums/Topic1353888-2893-1.aspxI keep receiving his error every Monday, after my Sunday's Integrity job schedule[code="plain"]"DBCC CHECKDB WITH NO_INFOMSGS " failed with the following error: "Database 'xxxxxxxxxxx' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems w... The package execution fa... The step failed.[/code]1st time the job ran, it went ok. After that, it started failing.The database is not in suspect state. It is up and running.I actually ran a DBCC myself, not via job, and gave no errors; but that does not mean it is not corrupted, still it can be. This is the only database on same server and drive that it is failing the Integrity job. And the Server Admin states there is no server or disk problem.Here's the SQL version: Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1) Yeah, I know, old stuff, but no plans to upgrade that to Denali or SQL2008 soon... :-( ... it is what it is ...Any ideas?Tue, 04 Sep 2012 07:37:47 GMTsql-loverhttp://www.sqlservercentral.com/Forums/Topic1380806-2893-1.aspxThe night of oct-30 we upgraded our production A/P cluster from 2k8 sp3 to 2012 on new HW.We shutdown sql, moved the luns to the new HW, and attached all the DB's. The attach/upgrade went smoothly, with no errors.The next CHECKDB found some corruption in our 2.0 TB archival DB.Full output is in attachment.[code]DateTime: 2012-11-03 04:06:09Command: DBCC CHECKDB ([GB_PurgedData]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITYMsg 8909, Level 16, State 1, Server SQL2VCLUSTER, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:156655154) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).Msg 8909, Level 16, State 1, Server SQL2VCLUSTER, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:156655155) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).Msg 8939, Level 16, State 98, Server SQL2VCLUSTER, Line 1Table error: Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 71881342401773568 (type LOB data), page (1:156655153). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.Msg 8928, Level 16, State 1, Server SQL2VCLUSTER, Line 1Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 71881342401773568 (type LOB data): Page (1:156655153) could not be processed. See other errors for details.Msg 8928, Level 16, State 1, Server SQL2VCLUSTER, Line 1Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 71881342401773568 (type LOB data): Page (1:156655154) could not be processed. See other errors for details.Msg 8928, Level 16, State 1, Server SQL2VCLUSTER, Line 1Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 71881342401773568 (type LOB data): Page (1:156655155) could not be processed. See other errors for details.Msg 8965, Level 16, State 1, Server SQL2VCLUSTER, Line 1Table error: Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 71881342401773568 (type LOB data). The off-row data node at page (1:156655154), slot 0, text ID 1867186176 is referenced by page (1:146589647), slot 7, but was not seen in the scan.Msg 8965, Level 16, State 1, Server SQL2VCLUSTER, Line 1Table error: Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 71881342401773568 (type LOB data). The off-row data node at page (1:156655154), slot 1, text ID 1617690624 is referenced by page (1:146589647), slot 8, but was not seen in the scan.Msg 8965, Level 16, State 1, Server SQL2VCLUSTER, Line 1Table error: Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 71881342401773568 (type LOB data). The off-row data node at page (1:156655153), slot 0, text ID 1867186176 is referenced by page (1:146589647), slot 7, but was not seen in the scan.Msg 8965, Level 16, State 1, Server SQL2VCLUSTER, Line 1Table error: Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 71881342401773568 (type LOB data). The off-row data node at page (1:156655155), slot 0, text ID 1617690624 is referenced by page (1:146589647), slot 8, but was not seen in the scan.Msg 8929, Level 16, State 1, Server SQL2VCLUSTER, Line 1Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 72057594043236352 (type In-row data): Errors found in off-row data with ID 1867186176 owned by data record identified by RID = (1:20493:10)Msg 8929, Level 16, State 1, Server SQL2VCLUSTER, Line 1Object ID 1605580758, index ID 0, partition ID 72057594040418304, alloc unit ID 72057594043236352 (type In-row data): Errors found in off-row data with ID 1867186176 owned by data record identified by RID = (1:9595580:23)Msg 8929, Level 16, State 1, Server SQL2VCLUSTER, Line 1<<several thousand similiar rows omitted...>>CHECKDB found 0 allocation errors and 2 consistency errors not associated with any single object.CHECKDB found 0 allocation errors and 6916 consistency errors in table 'PurgedItems_old' (object ID 1605580758).CHECKDB found 0 allocation errors and 6918 consistency errors in database 'GB_PurgedData'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (GB_PurgedData).Outcome: FailedDuration: 04:12:50DateTime: 2012-11-03 08:18:59[/code]The referenced table [PurgedItems_old] is a 1.5TB 300 mil row heap. (No criticism please -- I inherited it. New data goes into a partitioned table with a clustered index. I've been slowly moving data. )Timeline (I have all these backups):10/24 -- FULL Backup with checksum, restore verifyonly successful10/27 -- DBCC CHECKDB completes clean with NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY10/30 -- DIFF Backup with checksum, restore verifyonly successful10/30 -- DIFF Backup with checksum, restore verifyonly successful -- right before upgrade10/30 -- Upgrade to SQL 201211/1 -- DIFF Backup with checksum, restore verifyonly successful11/2 -- DIFF Backup with checksum, restore verifyonly successful11/3 -- DIFF Backup with checksum, restore verifyonly successful11/3 -- DBCC CHECKDB reports errors11/4 -- DIFF Backup with checksum, restore verifyonly successfulI don't have disk space to restore another copy of the DB. I think that page restore of page ID (1:156655154) and page ID (1:156655155) is my next step, but which backup to use? That table shouldn't have changed since the last FULL.both pages seem to have been zero'd out...DBCC PAGE (Gb_purgeddata, 1, 156655154, 2) returns:[code]PAGE: (0:0)BUFFER:BUF @0x0000008195083000bpage = 0x0000002196574000 bhash = 0x0000000000000000 bpageno = (1:156655154)bdbid = 16 breferences = 0 bcputicks = 0bsampleCount = 0 bUse1 = 64433 bstat = 0x809blog = 0x2121215a bnext = 0x0000000000000000 PAGE HEADER:Page @0x0000002196574000m_pageId = (0:0) m_headerVersion = 0 m_type = 0m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0m_objId (AllocUnitId.idObj) = 0 m_indexId (AllocUnitId.idInd) = 0 Metadata: AllocUnitId = 0Metadata: PartitionId = 0 Metadata: IndexId = -1 Metadata: ObjectId = 0m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 0m_slotCnt = 0 m_freeCnt = 0 m_freeData = 0m_reservedCnt = 0 m_lsn = (0:0:0) m_xactReserved = 0m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0DB Frag ID = 1 Allocation StatusGAM (1:156436992) = ALLOCATED SGAM (1:156436993) = NOT ALLOCATED PFS (1:156648384) = 0x42 ALLOCATED 80_PCT_FULL DIFF (1:156436998) = NOT CHANGEDML (1:156436999) = NOT MIN_LOGGED DATA:Memory Dump @0x000000B6C24A8000000000B6C24A8000: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8014: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8028: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A803C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8050: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8064: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8078: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A808C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A80A0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A80B4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A80C8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A80DC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A80F0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8104: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8118: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A812C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8140: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8154: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8168: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A817C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8190: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A81A4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A81B8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A81CC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A81E0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A81F4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8208: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A821C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8230: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8244: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8258: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A826C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8280: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8294: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A82A8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A82BC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A82D0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A82E4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A82F8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A830C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8320: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8334: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8348: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A835C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8370: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8384: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8398: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A83AC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A83C0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A83D4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A83E8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A83FC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8410: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8424: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8438: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A844C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8460: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8474: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8488: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A849C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A84B0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A84C4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A84D8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A84EC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8500: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8514: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8528: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A853C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8550: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8564: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8578: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A858C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A85A0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A85B4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A85C8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A85DC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A85F0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8604: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8618: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A862C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8640: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8654: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8668: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A867C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8690: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A86A4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A86B8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A86CC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A86E0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A86F4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8708: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A871C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8730: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8744: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8758: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A876C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8780: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8794: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A87A8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A87BC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A87D0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A87E4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A87F8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A880C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8820: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8834: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8848: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A885C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8870: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8884: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8898: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A88AC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A88C0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A88D4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A88E8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A88FC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8910: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8924: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8938: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A894C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8960: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8974: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8988: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A899C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A89B0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A89C4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A89D8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A89EC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8A00: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8A14: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8A28: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8A3C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8A50: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8A64: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8A78: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8A8C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8AA0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8AB4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8AC8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8ADC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8AF0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8B04: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8B18: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8B2C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8B40: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8B54: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8B68: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8B7C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8B90: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8BA4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8BB8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8BCC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8BE0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8BF4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8C08: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8C1C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8C30: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8C44: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8C58: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8C6C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8C80: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8C94: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8CA8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8CBC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8CD0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8CE4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8CF8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8D0C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8D20: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8D34: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8D48: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8D5C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8D70: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8D84: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8D98: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8DAC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8DC0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8DD4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8DE8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8DFC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8E10: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8E24: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8E38: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8E4C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8E60: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8E74: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8E88: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8E9C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8EB0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8EC4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8ED8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8EEC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8F00: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8F14: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8F28: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8F3C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8F50: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8F64: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8F78: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8F8C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8FA0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8FB4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8FC8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8FDC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A8FF0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9004: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9018: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A902C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9040: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9054: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9068: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A907C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9090: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A90A4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A90B8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A90CC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A90E0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A90F4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9108: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A911C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9130: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9144: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9158: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A916C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9180: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9194: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A91A8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A91BC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A91D0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A91E4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A91F8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A920C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9220: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9234: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9248: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A925C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9270: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9284: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9298: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A92AC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A92C0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A92D4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A92E8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A92FC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9310: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9324: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9338: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A934C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9360: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9374: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9388: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A939C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A93B0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A93C4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A93D8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A93EC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9400: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9414: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9428: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A943C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9450: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9464: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9478: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A948C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A94A0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A94B4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A94C8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A94DC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A94F0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9504: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9518: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A952C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9540: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9554: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9568: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A957C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9590: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A95A4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A95B8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A95CC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A95E0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A95F4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9608: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A961C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9630: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9644: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9658: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A966C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9680: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9694: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A96A8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A96BC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A96D0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A96E4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A96F8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A970C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9720: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9734: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9748: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A975C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9770: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9784: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9798: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A97AC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A97C0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A97D4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A97E8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A97FC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9810: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9824: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9838: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A984C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9860: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9874: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9888: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A989C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A98B0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A98C4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A98D8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A98EC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9900: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9914: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9928: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A993C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9950: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9964: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9978: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A998C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A99A0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A99B4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A99C8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A99DC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A99F0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9A04: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9A18: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9A2C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9A40: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9A54: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9A68: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9A7C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9A90: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9AA4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9AB8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9ACC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9AE0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9AF4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9B08: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9B1C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9B30: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9B44: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9B58: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9B6C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9B80: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9B94: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9BA8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9BBC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9BD0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9BE4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9BF8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9C0C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9C20: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9C34: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9C48: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9C5C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9C70: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9C84: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9C98: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9CAC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9CC0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9CD4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9CE8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9CFC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9D10: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9D24: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9D38: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9D4C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9D60: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9D74: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9D88: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9D9C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9DB0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9DC4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9DD8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9DEC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9E00: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9E14: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9E28: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9E3C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9E50: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9E64: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9E78: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9E8C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9EA0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9EB4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9EC8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9EDC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9EF0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9F04: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9F18: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9F2C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9F40: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9F54: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9F68: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9F7C: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9F90: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9FA4: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9FB8: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9FCC: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9FE0: 00000000 00000000 00000000 00000000 00000000 ....................000000B6C24A9FF4: 00000000 00000000 00000000 ............DBCC execution completed. If DBCC printed error messages, contact your system administrator.[/code]Sun, 04 Nov 2012 11:23:37 GMTSpringTownDBAhttp://www.sqlservercentral.com/Forums/Topic1380469-2893-1.aspxWhile i try to attach the mdf file i got the error, The Error is: [b]DatabaseName.mdf is not SQL Server Database Primary Data File[/b]The[b] SQL server Error No. 5171[/b]Fri, 02 Nov 2012 09:48:16 GMTtamil.selvanmcahttp://www.sqlservercentral.com/Forums/Topic1379135-2893-1.aspx1. Source of recordset SQL Server stored procedure.2. Means of access: ADODB recordset in Excel VBA, using adOpenForwardOnly3. Referenced library in VBA: Microsoft ActiveX Data Objects 2.8 Library4. All fields turn up in the expected text format when I run the stored procedure right on the SQL server management studio.4. In Windows 7, all fields are delivered as they should.5. In Windows XP, two of the text fields (not too long, under 200 characters) become garbled.By "garbled" I mean turn up with octet values in the range 0 to 31 (i.e., less than a space) with a few,scattered in the field, of higher values.Any ideas? I'm stumped!Tue, 30 Oct 2012 20:23:46 GMTimsotohttp://www.sqlservercentral.com/Forums/Topic1372858-2893-1.aspxI have '08 instance that has two dbs in it. No SQL Server backups, only OS level. One of the dbs started getting the 605 logical fetch error a few days ago. It's now hung in "in recovery" state. Can I restore this db simply by shutting the instance down and then restoring the database file(at the OS level) from b4 the errors started? Then just start the service?Mon, 15 Oct 2012 11:46:46 GMTunderwoodmfhttp://www.sqlservercentral.com/Forums/Topic1372936-2893-1.aspxHi, I read in several places that it is recommended to restore a database backup instead of running REPAIR_ALLOW_DATA_LOSS to fix corruption issues. I'm just wondering how this could be an acceptable solution. Lets say you run a full CHECKDB once a week and spot corruption, but you find the corruption happened 6 days prior so the nightly backups going back 6 days would all have the corrupt pages. Wouldn't you have to restore an old database backup and lose almost a week of data? Is this really what is recommended or am I missing something?I've read about using a old backup to restore over individual corrupt pages which would make more sense. However, what is the best way to determine how far back you need to go to find the latest backup before the corruption happened? How can you determine WHEN the corruption happened?Thanks.Mon, 15 Oct 2012 14:27:31 GMTahendersonhttp://www.sqlservercentral.com/Forums/Topic1366298-2893-1.aspxOne-time DB job was scheduled at night to add two columns (computed, persistent) on a large table (5 GB together with indexes, witout compression about 10GB).It is a compressed heap with several nonclustered indexes also compressed, partitioned by month with aligned partitions.The command in the job was just "ALTER TABLE xy ..." that adds two columns.The transaction lasted for several hours, and failed.After that, the database was online, but most of users users got very odd errors every time:[code="plain"]Error: 615, Severity: 21, State: 1Could not find database ID 6144, name '6144'. The database may be offline. Wait a few minutes and try again.[/code]Some users could use the db normally, but most of the users got hundreds of that message, sometimes with different number as the "name" of the database. Such numeric names of DB of course do not exist and have never existed on the server.Totally crazy!DB was online and DBCC CHECKDB found no errors.But almost none of the users could use the DB, so I had to fix it somehow.Error log for the job reported this set of errors:[code="plain"]TCP Provider: An existing connection was forcibly closed by the remote host.[SQLSTATE 08S01] (Error 10054)Communication link failure [SQLSTATE 08S01] (Error 10054)The transaction log for database '*DBNAME*' is full.To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases[SQLSTATE 42000] (Error 9002) The log for database '*DBNAME*' is not available. Check the event log for related error messages. Resolve any errors and restart the database.[SQLSTATE HY000] (Error 9001) During undoing of a logged operation in database '*DBNAME*', an error occurred at log record ID (388242:11656:483).Typically, the specific failure is logged previously as an error in the Windows Event Log service.[b]Restore the database or file from a backup, or repair the database.[/b][SQLSTATE HY000] (Error 3314)[/code]During a job execution, a Transaction log grew from 6 to 36GB. That is still not enough to fill-up the disc space, but not far from it (several GB were free).So, I wonder why the "Transaction log full" error ?After "transaction log full" striked, a huge rollback was performed. But that rollback also failed.I ended up in a corrupted DB (although DBCC CHECKDB says it is ok, it is NOT) that is unrecoverable, except restoring it from the backup.So, I did restore it to the point in time just before that ALTER TABLE started. Losing all the data changes and inputs after that point.Now users can use it and looks fine, but I'm afraid that it can happen again if I don't find a reason why this severe corruption occurred.So, please help. I have to find out. Because, I can't believe it is normal that one gets a corrupted db if transaction log fills the disk (and I don't believe that disk was totally full).The point is - a simple ALTER TABLE ADD COLUMN on 5GB table generates 30+GB of transaction log, and unrecoverable corruption of the database.So, I wont run that command again until I find the cause of corruption.Is it really common in SQL server if you run out of disk space that you get corrupted DB ?Version is SQL 2008R2 RTM on a 2-node cluster.Sun, 30 Sep 2012 15:56:29 GMTVedran Kesegichttp://www.sqlservercentral.com/Forums/Topic1365150-2893-1.aspxWhen you rollback a transaction, how does sql know what to rollback and indeed what data to replace it with?A proper technical answer please.Thu, 27 Sep 2012 05:22:34 GMTlotusnoteshttp://www.sqlservercentral.com/Forums/Topic1359997-2893-1.aspxPrimary server databases are working fine but my secondary databases are going into suspected mode.No of databases 20 all are log shipped.2 of my database went into suspected mode so i recovered it from my last nite full back and restored the remaning t-log backup with no issue.This shows my transaction logs are not corrupted.Now again today of my standby database went into suspected mode.Also i m able to restore the transaction log with norecovery but cannot with standy as it says it is in sspected mode.My primary databases are working fine and my full backup,t-log backup are fine with no issue.I want to know why my databases is going into suspected mode which is in standby mode.Kindly suggest.Sqlserver 2008 R2 and windows 2003Mon, 17 Sep 2012 00:57:08 GMTsamsql