InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 18:42:24 GMT20http://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxGail...!! Kudos...!! Its working perfect now... Clients are very happy. Thnx a lot for your guidance again.:-)Thu, 24 Jan 2013 02:50:33 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxThanks a lot Gail...!!!I completed all the activity with no error and this time took full backuk before doing anything.:-D. I handed over the system to check if there is any error left or any data loss, am just waiting clients reply.Heartly Thanks to you and SQLSERVERCENTRAL which is Online\LIVE help for fresh DBA like me.Tue, 22 Jan 2013 23:08:45 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxPTPortal.PTPortalUser.PTJOBLOGS has a corruption in its clustered index. Take the DB into single user mode and run DBCC CheckDB(PTPortal, repair_rebuild)Fri, 18 Jan 2013 04:00:49 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxHello Gail,I think there is no index on PTPortal db..!! I ran SELECT 'dbcc dbreindex(''PTPortal.DBO.' +name+ ''')' FROM sysobjects and did not found those corrupted tables there... Just can see that there are primary constraints defined on both the tables.Can you gimme any other option to know whether there are any indexes declared on that table ?If there are no indexes that why we got that index mismatch error in dbcc checkdb ?Fri, 18 Jan 2013 03:27:22 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote][b]jitendra.padhiyar (1/18/2013)[/b][hr]Yesterday I tried to run checkdb with repair_rebuild option but fails due to log file full. I will try again after shrinking db log file.[/quote]Shrinking a full log is like trying to move the contents of a 5 litre bucket of water in to a 2 litre bucket. The log is full. ie, there is no free space in the log and it needs to grow. Shrinking releases free space to the OS. Shrinking's the exact opposite of what you need to do.Please read through this - [url=http://www.sqlservercentral.com/articles/64582/]Managing Transaction Logs[/url]Fri, 18 Jan 2013 02:56:30 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxYesterday I tried to run checkdb with repair_rebuild option but fails due to log file full. I will try again after shrinking db log file.@Gail: Is it possible to perform checkdb on specific tables only ? Or is it possible to perform re-indexing on specific table in SQL Server 2000 ?Fri, 18 Jan 2013 00:04:21 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxPut the DB into single user mode and run CheckDB(<database name>, repair_rebuild)Thu, 17 Jan 2013 05:02:30 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxHello Gilamonster,I ran DBCC Checkdb as below:DBCC CHECKDB (PTPortal) WITH NO_INFOMSGS, ALL_ERRORMSGS;And got below error message:Server: Msg 8937, Level 16, State 1, Line 1Table error: Object ID 901578250, index ID 1. B-tree page (1:753306) has two parent nodes (1:4661), slot 143 and (1:609), slot 1.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 901578250, index ID 1. Index node page (1:609), slot 180 refers to child page (1:753307) and previous child (1:753306), but they were not encountered.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 901578250, index ID 1. Page (1:753308) is missing a reference from previous page (1:753307). Possible chain linkage problem.CHECKDB found 0 allocation errors and 3 consistency errors in table 'PTPortalUser.PTJOBLOGS' (object ID 901578250).CHECKDB found 0 allocation errors and 3 consistency errors in database 'PTPortal'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (PTPortal ).Can I go with Rebuilding of indexes using DBCC REINDEX ? Or pls suggest me better way to cope with this error.Thu, 17 Jan 2013 03:53:03 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote][b]Jayanth_Kurup (1/15/2013)[/b][hr]@Gail , would it make sense now to add a clustered index or rebuild the clustered index ?[/quote]No, it will fail.[quote]Are you able to access the table , can you create a copy of the table ?[/quote]No, it will fail.Tue, 15 Jan 2013 05:47:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote][b]jitendra.padhiyar (1/15/2013)[/b][hr]Just googled error message and found this issue occurs because the SHRINK operation cannot remove a page from the SYSFILES1 system table on the primary data file of the database. And we can fix it by applying latest service pack of SQL Server 2000!! [/quote]Err, no it is not caused by shrink trying to remove a page from sysfiles1 and no you cannot fix it by applying a service pack.Tue, 15 Jan 2013 05:47:01 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote][b]jitendra.padhiyar (1/15/2013)[/b][hr]The were trying to perform below delete operation:DELETE FROM PTPortalUser.PTJOBLOGS WHERE INSTANCEID < 614469and got error message:Msg 8908, Level 22, State 6, Line 1Table error: Database ID 23, object ID 901578250, index ID 0. Chain linkage mismatch. (1:753306)->next = (1:753307), but (1:753307)->prev = (1:706408).It seems its consistency error that Checkdb was not able to repair. Should I run checkdb again with All_ErrorMSGS ? to know whts going on ? OR any other way to cope with this error ? Indexid=0 seems cluster index issue.. [/quote]As I asked earlier...[quote]Now, please run this so I can see if there are any remaining errors[code]DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS[/code][/quote]Tue, 15 Jan 2013 05:45:43 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxI wouldnt start adding service packs ( sql 2000 and still ahve serice packs you need to add??) to fix a issue your facing now. Applying service packs need to be thought out properly.Are you able to access the table , can you create a copy of the table ?Tue, 15 Jan 2013 04:30:47 GMTJayanth_Kuruphttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxindex id 0 is heap , just to get a better idea for future use. did u get this error after a power failure ?Did you try running a checkdsk on the disk drives?@Gail , would it make sense now to add a clustered index or rebuild the clustered index ?Tue, 15 Jan 2013 04:27:57 GMTJayanth_Kuruphttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxJust googled error message and found this issue occurs because the SHRINK operation cannot remove a page from the SYSFILES1 system table on the primary data file of the database. And we can fix it by applying latest service pack of SQL Server 2000!! Is it advisable ?? Please help me masters...!Tue, 15 Jan 2013 04:23:23 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxThanks a lot GilaMonster and Joe !I just checked with client end, and found they are ok with the performance of sql server but... they got one error while performing Delete operation with PTJOBLOGS.. (:The were trying to perform below delete operation:DELETE FROM PTPortalUser.PTJOBLOGS WHERE INSTANCEID < 614469and got error message:Msg 8908, Level 22, State 6, Line 1Table error: Database ID 23, object ID 901578250, index ID 0. Chain linkage mismatch. (1:753306)->next = (1:753307), but (1:753307)->prev = (1:706408).It seems its consistency error that Checkdb was not able to repair. Should I run checkdb again with All_ErrorMSGS ? to know whts going on ? OR any other way to cope with this error ? Indexid=0 seems cluster index issue.. Tue, 15 Jan 2013 04:11:14 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxBefore you go further down this rabbit hole, do you have backups of this database? It may be better to restore from full/logs before proceeding.I hope those backups you removed to clear up space on the drive were not from the database you are working on. If they were I hope they were moved and not deleted...Tue, 15 Jan 2013 03:05:27 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote][b]jitendra.padhiyar (1/15/2013)[/b][hr]Ohh.. Is there any way to know how much data lost? Or how to find what table affected by that ?[/quote]How much, no, not after the fact. Which table, yes. The tables PTJOBOPHISTORY and PTJOBLOGSTue, 15 Jan 2013 02:49:05 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxOhh.. Is there any way to know how much data lost? Or how to find what table affected by that ?Tue, 15 Jan 2013 02:35:00 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxErr... Joie asked you to run CheckDB with no_infomsgs, not CheckDB with the repair allow data loss option specified. Do you have any idea what data was lost when you ran that?Now, please run this so I can see if there are any remaining errors[code]DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS[/code]Tue, 15 Jan 2013 02:28:53 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxDBCC Checkdb completed after long time of about 3 hours...!!! There are 0 allocation error but have seen some consistency errors.. :crazy: Below is the message that i receive after DBCC checkdb run.. can anyone let me know if this is of any dangerous cause ?The second line shows about full log file that I backup after dbcc check.=======================================================Server: Msg 9002, Level 17, State 6, Line 1The log file for database 'PTPortal' is full. Back up the transaction log for the database to free up some log space.Server: Msg 9002, Level 17, State 1, Line 1The log file for database 'PTPortal' is full. Back up the transaction log for the database to free up some log space.DBCC results for 'PTPortal'.DBCC results for 'sysobjects'.There are 408 rows in 7 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 632 rows in 30 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 2210 rows in 37 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 26 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 204 rows in 33 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 78 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 18 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 8 rows in 4 pages for object 'sysproperties'.DBCC results for 'sysdepends'.There are 1221 rows in 7 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 1 rows in 1 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 0 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'PTPortalUser.PTFOLDERSTATUS'.There are 7471 rows in 42 pages for object 'PTPortalUser.PTFOLDERSTATUS'.DBCC results for 'PTPortalUser.PTDTMSECTIONS'.There are 6 rows in 1 pages for object 'PTPortalUser.PTDTMSECTIONS'.DBCC results for 'PTPortalUser.PTDTMIDENTIFIERS'.There are 65 rows in 1 pages for object 'PTPortalUser.PTDTMIDENTIFIERS'.DBCC results for 'PTPortalUser.PTPREFS'.There are 293819 rows in 3578 pages for object 'PTPortalUser.PTPREFS'.DBCC results for 'PTPortalUser.PTOBJECTCOUNTERS'.There are 43 rows in 1 pages for object 'PTPortalUser.PTOBJECTCOUNTERS'.DBCC results for 'PTPortalUser.PTPAGES'.There are 28970 rows in 408 pages for object 'PTPortalUser.PTPAGES'.DBCC results for 'PTPortalUser.PTCLASSDESCRIPTION'.There are 42 rows in 1 pages for object 'PTPortalUser.PTCLASSDESCRIPTION'.DBCC results for 'PTPortalUser.PTOBJECTLOCKS'.There are 0 rows in 1 pages for object 'PTPortalUser.PTOBJECTLOCKS'.DBCC results for 'PTPortalUser.PTPAGEGADGETS'.There are 4526 rows in 34 pages for object 'PTPortalUser.PTPAGEGADGETS'.DBCC results for 'PTPortalUser.PTSERVERCONFIG'.There are 67 rows in 1 pages for object 'PTPortalUser.PTSERVERCONFIG'.DBCC results for 'PTPortalUser.PTCOMMUNITIES'.There are 227 rows in 8 pages for object 'PTPortalUser.PTCOMMUNITIES'.DBCC results for 'PTPortalUser.PTDOCTYPEINFO'.There are 2 rows in 1 pages for object 'PTPortalUser.PTDOCTYPEINFO'.DBCC results for 'PTPortalUser.PTROLES'.There are 3 rows in 1 pages for object 'PTPortalUser.PTROLES'.DBCC results for 'PTPortalUser.PTCOMMPREFS'.There are 251 rows in 3 pages for object 'PTPortalUser.PTCOMMPREFS'.DBCC results for 'PTPortalUser.PTUSERS'.There are 28057 rows in 1458 pages for object 'PTPortalUser.PTUSERS'.DBCC results for 'PTPortalUser.PTAPPLICATIONS'.There are 1 rows in 1 pages for object 'PTPortalUser.PTAPPLICATIONS'.DBCC results for 'PTPortalUser.PTMANDGADGETS'.There are 61 rows in 1 pages for object 'PTPortalUser.PTMANDGADGETS'.DBCC results for 'PTPortalUser.PTCAPABILITIES'.There are 3 rows in 1 pages for object 'PTPortalUser.PTCAPABILITIES'.DBCC results for 'PTPortalUser.PTCOMMTEMPLATES'.There are 2 rows in 1 pages for object 'PTPortalUser.PTCOMMTEMPLATES'.DBCC results for 'PTPortalUser.PTUSERTYPES'.There are 2 rows in 1 pages for object 'PTPortalUser.PTUSERTYPES'.DBCC results for 'PTPortalUser.PTCREDENTIALPROPERTIES'.There are 0 rows in 0 pages for object 'PTPortalUser.PTCREDENTIALPROPERTIES'.DBCC results for 'PTPortalUser.PTGADGETBUNDLES'.There are 1 rows in 1 pages for object 'PTPortalUser.PTGADGETBUNDLES'.DBCC results for 'PTPortalUser.PTUSERGROUPS'.There are 24474 rows in 1510 pages for object 'PTPortalUser.PTUSERGROUPS'.DBCC results for 'PTPortalUser.PTCREDENTIALVALUES'.There are 0 rows in 0 pages for object 'PTPortalUser.PTCREDENTIALVALUES'.DBCC results for 'PTPortalUser.PTPAGETEMPLATES'.There are 3 rows in 1 pages for object 'PTPortalUser.PTPAGETEMPLATES'.DBCC results for 'PTPortalUser.PTUSERLINKS'.There are 253933 rows in 4841 pages for object 'PTPortalUser.PTUSERLINKS'.DBCC results for 'PTPortalUser.PTUSERROLELINKS'.There are 1 rows in 1 pages for object 'PTPortalUser.PTUSERROLELINKS'.DBCC results for 'PTPortalUser.PTCOMTEMPPAGETEMPS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTCOMTEMPPAGETEMPS'.DBCC results for 'PTPortalUser.PTUSERGROUPPROPMAP'.There are 5 rows in 1 pages for object 'PTPortalUser.PTUSERGROUPPROPMAP'.DBCC results for 'PTPortalUser.PTGROUPROLELINKS'.There are 4 rows in 1 pages for object 'PTPortalUser.PTGROUPROLELINKS'.DBCC results for 'PTPortalUser.PTGADGBUNDLGADGETS'.There are 9 rows in 1 pages for object 'PTPortalUser.PTGADGBUNDLGADGETS'.DBCC results for 'PTPortalUser.PTDGROUPLINKSCRATCH'.There are 0 rows in 1 pages for object 'PTPortalUser.PTDGROUPLINKSCRATCH'.DBCC results for 'PTPortalUser.PTROLECAPABILITYLINKS'.There are 5 rows in 1 pages for object 'PTPortalUser.PTROLECAPABILITYLINKS'.DBCC results for 'PTPortalUser.PTPAGETEMPGADGETS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTPAGETEMPGADGETS'.DBCC results for 'PTPortalUser.PTGROUPLINKS'.There are 14155 rows in 72 pages for object 'PTPortalUser.PTGROUPLINKS'.DBCC results for 'PTPortalUser.PTSITEMAPFOLDERS'.There are 298 rows in 14 pages for object 'PTPortalUser.PTSITEMAPFOLDERS'.DBCC results for 'PTPortalUser.PTGROUPSINGROUPS'.There are 85944 rows in 376 pages for object 'PTPortalUser.PTGROUPSINGROUPS'.DBCC results for 'PTPortalUser.PTSITEMAPLINKS'.There are 6 rows in 2 pages for object 'PTPortalUser.PTSITEMAPLINKS'.DBCC results for 'PTPortalUser.PTSUACONFIG'.There are 6 rows in 1 pages for object 'PTPortalUser.PTSUACONFIG'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'PTPortalUser.PTMYCOMMUNITIES'.There are 803 rows in 5 pages for object 'PTPortalUser.PTMYCOMMUNITIES'.DBCC results for 'PTPortalUser.PTSUARANGELOCKS'.There are 0 rows in 1 pages for object 'PTPortalUser.PTSUARANGELOCKS'.DBCC results for 'PTPortalUser.PTSYNCMEMBERS'.There are 0 rows in 1 pages for object 'PTPortalUser.PTSYNCMEMBERS'.DBCC results for 'PTPortalUser.PTFEDPORTALS'.There are 1 rows in 1 pages for object 'PTPortalUser.PTFEDPORTALS'.DBCC results for 'PTPortalUser.PTSYNCLINKS'.There are 0 rows in 1 pages for object 'PTPortalUser.PTSYNCLINKS'.DBCC results for 'PTPortalUser.PTFEDSEARCHREG'.There are 3 rows in 1 pages for object 'PTPortalUser.PTFEDSEARCHREG'.DBCC results for 'PTPortalUser.PTAUTHSOURCES'.There are 21 rows in 1 pages for object 'PTPortalUser.PTAUTHSOURCES'.DBCC results for 'PTPortalUser.PTGCSERVERS'.There are 31 rows in 1 pages for object 'PTPortalUser.PTGCSERVERS'.DBCC results for 'PTPortalUser.PTLOCKEDACCOUNTS'.There are 4987 rows in 134 pages for object 'PTPortalUser.PTLOCKEDACCOUNTS'.DBCC results for 'PTPortalUser.PTSEARCHSTATUS'.There are 59299 rows in 504 pages for object 'PTPortalUser.PTSEARCHSTATUS'.DBCC results for 'PTPortalUser.PTDELETEDUSERS'.There are 1 rows in 1 pages for object 'PTPortalUser.PTDELETEDUSERS'.DBCC results for 'PTPortalUser.PTACLSYNCMAP'.There are 51 rows in 2 pages for object 'PTPortalUser.PTACLSYNCMAP'.DBCC results for 'PTPortalUser.PTMYPAGESPREFS'.There are 253062 rows in 2567 pages for object 'PTPortalUser.PTMYPAGESPREFS'.DBCC results for 'PTPortalUser.PTACLSYNCUNMAPPED'.There are 7 rows in 1 pages for object 'PTPortalUser.PTACLSYNCUNMAPPED'.DBCC results for 'PTPortalUser.PTDELETEDGROUPS'.There are 28923 rows in 2329 pages for object 'PTPortalUser.PTDELETEDGROUPS'.DBCC results for 'PTPortalUser.PTINVITATIONS'.There are 1 rows in 1 pages for object 'PTPortalUser.PTINVITATIONS'.DBCC results for 'PTPortalUser.PTJOBS'.There are 57 rows in 2 pages for object 'PTPortalUser.PTJOBS'.DBCC results for 'PTPortalUser.PTCURRENTINVITES'.There are 1 rows in 1 pages for object 'PTPortalUser.PTCURRENTINVITES'.DBCC results for 'PTPortalUser.PTJOBLISTS'.There are 63 rows in 1 pages for object 'PTPortalUser.PTJOBLISTS'.DBCC results for 'PTPortalUser.PTUSERINTERFACES'.There are 3 rows in 1 pages for object 'PTPortalUser.PTUSERINTERFACES'.DBCC results for 'PTPortalUser.PTJOBHISTORY'.There are 153855 rows in 5643 pages for object 'PTPortalUser.PTJOBHISTORY'.DBCC results for 'PTPortalUser.PTPROCLOG'.There are 1286532 rows in 20315 pages for object 'PTPortalUser.PTPROCLOG'.DBCC results for 'PTPortalUser.PTACTIVITIES'.There are 44 rows in 2 pages for object 'PTPortalUser.PTACTIVITIES'.DBCC results for 'PTPortalUser.PTJOBOPHISTORY'.Server: Msg 8928, Level 16, State 1, Line 1Object ID 901578250, index ID 0: Page (1:753306) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 901578250, index ID 0, page (1:753306). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 1Object ID 901578250, index ID 0: Page (1:753307) could not be processed. See other errors for details.Server: Msg 8976, Level 16, State 1, Line 1Table error: Object ID 901578250, index ID 1. Page (1:753306) was not seen in the scan although its parent (1:1210486) and previous (1:753305) refer to it. Check any previous errors.Server: Msg 8980, Level 16, State 1, Line 1Table error: Object ID 901578250, index ID 1. Index node page (1:1210486), slot 180 refers to child page (1:753307) and previous child (1:753306), but they were not encountered.Server: Msg 8978, Level 16, State 1, Line 1Table error: Object ID 901578250, index ID 1. Page (1:753308) is missing a reference from previous page (1:753307). Possible chain linkage problem.There are 172895 rows in 9338 pages for object 'PTPortalUser.PTJOBOPHISTORY'.DBCC results for 'PTPortalUser.PTACTIVITYSECURITY'.There are 97 rows in 1 pages for object 'PTPortalUser.PTACTIVITYSECURITY'.DBCC results for 'PTPortalUser.PTJOBLOGS'. The error has been repaired. The error has been repaired. The error has been repaired. Could not repair this error. Repairing this error requires other errors to be corrected first. Repairing this error requires other errors to be corrected first.Repair: Page (1:753306) has been deallocated from object ID 901578250, index ID 0.Repair: Page (1:753307) has been deallocated from object ID 901578250, index ID 0.There are 23031283 rows in 4173108 pages for object 'PTPortalUser.PTJOBLOGS'.CHECKDB found 0 allocation errors and 6 consistency errors in table 'PTPortalUser.PTJOBLOGS' (object ID 901578250).CHECKDB fixed 0 allocation errors and 3 consistency errors in table 'PTPortalUser.PTJOBLOGS' (object ID 901578250).DBCC results for 'PTPortalUser.PTEXTOPERATIONS'.There are 25 rows in 2 pages for object 'PTPortalUser.PTEXTOPERATIONS'.DBCC results for 'PTPortalUser.PTJOBFOLDERS'.There are 3 rows in 1 pages for object 'PTPortalUser.PTJOBFOLDERS'.DBCC results for 'PTPortalUser.PTMIGRATION'.There are 91559 rows in 2038 pages for object 'PTPortalUser.PTMIGRATION'.DBCC results for 'PTPortalUser.PTJOBSERVERS'.There are 4 rows in 1 pages for object 'PTPortalUser.PTJOBSERVERS'.DBCC results for 'PTPortalUser.PTMIGRATIONHISTORY'.There are 3266 rows in 61 pages for object 'PTPortalUser.PTMIGRATIONHISTORY'.DBCC results for 'PTPortalUser.PTMIGRATIONPROFILES'.There are 13 rows in 1 pages for object 'PTPortalUser.PTMIGRATIONPROFILES'.DBCC results for 'PTPortalUser.PTPROFILESOURCES'.There are 7 rows in 1 pages for object 'PTPortalUser.PTPROFILESOURCES'.DBCC results for 'PTPortalUser.PTOBJECTPROPERTIES'.There are 21639 rows in 3790 pages for object 'PTPortalUser.PTOBJECTPROPERTIES'.DBCC results for 'PTPortalUser.PTUSERSIGNATURES'.There are 42809 rows in 372 pages for object 'PTPortalUser.PTUSERSIGNATURES'.DBCC results for 'PTPortalUser.PTOBJECTBLOBS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTOBJECTBLOBS'.DBCC results for 'PTPortalUser.PTUSERGROUPSIGNATURES'.There are 22705 rows in 255 pages for object 'PTPortalUser.PTUSERGROUPSIGNATURES'.DBCC results for 'PTPortalUser.PTSAVEDSEARCHES'.There are 795 rows in 26 pages for object 'PTPortalUser.PTSAVEDSEARCHES'.DBCC results for 'PTPortalUser.PTCOMMSECURITY'.There are 1134 rows in 7 pages for object 'PTPortalUser.PTCOMMSECURITY'.DBCC results for 'PTPortalUser.PTUSERINFOMAP'.There are 14 rows in 1 pages for object 'PTPortalUser.PTUSERINFOMAP'.DBCC results for 'PTPortalUser.PTFILTERS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTFILTERS'.DBCC results for 'PTPortalUser.PTPROFILESECTIONS'.There are 6 rows in 1 pages for object 'PTPortalUser.PTPROFILESECTIONS'.DBCC results for 'PTPortalUser.PTGADGETS'.There are 3455 rows in 236 pages for object 'PTPortalUser.PTGADGETS'.DBCC results for 'PTPortalUser.PTPAGESECURITY'.There are 4704 rows in 25 pages for object 'PTPortalUser.PTPAGESECURITY'.DBCC results for 'PTPortalUser.PTPROFILEPAGES'.There are 3 rows in 1 pages for object 'PTPortalUser.PTPROFILEPAGES'.DBCC results for 'PTPortalUser.PTWEBSERVICES'.There are 261 rows in 21 pages for object 'PTPortalUser.PTWEBSERVICES'.DBCC results for 'PTPortalUser.PTSUBPORTALS'.There are 6 rows in 1 pages for object 'PTPortalUser.PTSUBPORTALS'.DBCC results for 'PTPortalUser.PTDOCUMENTTYPES'.There are 12 rows in 1 pages for object 'PTPortalUser.PTDOCUMENTTYPES'.DBCC results for 'PTPortalUser.PTGUESTLOGINS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTGUESTLOGINS'.DBCC results for 'PTPortalUser.PTDATASOURCES'.There are 16 rows in 1 pages for object 'PTPortalUser.PTDATASOURCES'.DBCC results for 'PTPortalUser.PTBESTBETS'.There are 353 rows in 5 pages for object 'PTPortalUser.PTBESTBETS'.DBCC results for 'PTPortalUser.PTCRAWLERS'.There are 14 rows in 1 pages for object 'PTPortalUser.PTCRAWLERS'.DBCC results for 'PTPortalUser.PTADMINFOLDERSECURITY'.There are 5436 rows in 26 pages for object 'PTPortalUser.PTADMINFOLDERSECURITY'.DBCC results for 'PTPortalUser.PTBESTBETTARGETS'.There are 384 rows in 7 pages for object 'PTPortalUser.PTBESTBETTARGETS'.DBCC results for 'PTPortalUser.PTCRAWLERREJECTS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTCRAWLERREJECTS'.DBCC results for 'PTPortalUser.PTOBJECTSECURITY'.There are 112750 rows in 649 pages for object 'PTPortalUser.PTOBJECTSECURITY'.DBCC results for 'PTPortalUser.PTGADGETSECURITY'.There are 19146 rows in 99 pages for object 'PTPortalUser.PTGADGETSECURITY'.DBCC results for 'PTPortalUser.PTSEARCHLOGREPORTS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTSEARCHLOGREPORTS'.DBCC results for 'PTPortalUser.PTINTERNALCARDINFO'.There are 67249 rows in 756 pages for object 'PTPortalUser.PTINTERNALCARDINFO'.DBCC results for 'PTPortalUser.PTEXPRESSIONS'.There are 5 rows in 1 pages for object 'PTPortalUser.PTEXPRESSIONS'.DBCC results for 'PTPortalUser.PTTAXONOMISTS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTTAXONOMISTS'.DBCC results for 'PTPortalUser.PTEXPRESSIONSINEXPRESSIONS'.There are 2 rows in 1 pages for object 'PTPortalUser.PTEXPRESSIONSINEXPRESSIONS'.DBCC results for 'PTPortalUser.PTPROPERTIES'.There are 58 rows in 2 pages for object 'PTPortalUser.PTPROPERTIES'.DBCC results for 'PTPortalUser.PTSUBSCRIPTIONS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTSUBSCRIPTIONS'.DBCC results for 'PTPortalUser.PTPROPCLASSMAP'.There are 35 rows in 1 pages for object 'PTPortalUser.PTPROPCLASSMAP'.DBCC results for 'PTPortalUser.PTPAGEIDMAP'.There are 24965 rows in 72 pages for object 'PTPortalUser.PTPAGEIDMAP'.DBCC results for 'PTPortalUser.PTPICKLISTDATA'.There are 1 rows in 1 pages for object 'PTPortalUser.PTPICKLISTDATA'.DBCC results for 'PTPortalUser.PTPROPERTYDATA'.There are 202867 rows in 2375 pages for object 'PTPortalUser.PTPROPERTYDATA'.DBCC results for 'PTPortalUser.PTPROPERTYDATA_REF'.There are 790 rows in 8 pages for object 'PTPortalUser.PTPROPERTYDATA_REF'.DBCC results for 'PTPortalUser.PTLOCALIZATIONS'.There are 12441 rows in 169 pages for object 'PTPortalUser.PTLOCALIZATIONS'.DBCC results for 'BestBetsTargets'.There are 582 rows in 10 pages for object 'BestBetsTargets'.DBCC results for 'BestBets'.There are 265 rows in 5 pages for object 'BestBets'.DBCC results for 'PTPortalUser.PTADMINFOLDERS'.There are 1093 rows in 31 pages for object 'PTPortalUser.PTADMINFOLDERS'.DBCC results for 'PTPortalUser.PTADMINFOLDERIDPATHS'.There are 1093 rows in 64 pages for object 'PTPortalUser.PTADMINFOLDERIDPATHS'.DBCC results for 'PTPortalUser.PTADMINFOLDEROBJECTS'.There are 58746 rows in 304 pages for object 'PTPortalUser.PTADMINFOLDEROBJECTS'.DBCC results for 'PTPortalUser.PTAUDITMSGS'.There are 2646217 rows in 59698 pages for object 'PTPortalUser.PTAUDITMSGS'.DBCC results for 'PTPortalUser.LDAP_ORGANIZATION'.There are 1 rows in 1 pages for object 'PTPortalUser.LDAP_ORGANIZATION'.DBCC results for 'PTPortalUser.PTADMINFOLDERSHORTCUTS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTADMINFOLDERSHORTCUTS'.DBCC results for 'PTPortalUser.LDAP_ORG_UNITS'.There are 42 rows in 2 pages for object 'PTPortalUser.LDAP_ORG_UNITS'.DBCC results for 'PTPortalUser.LDAP_OBJECTCLASS_MAP'.There are 4 rows in 1 pages for object 'PTPortalUser.LDAP_OBJECTCLASS_MAP'.DBCC results for 'PTPortalUser.PTCARDS'.There are 14026 rows in 1002 pages for object 'PTPortalUser.PTCARDS'.DBCC results for 'PTPortalUser.PTCARDSECURITY'.There are 53633 rows in 215 pages for object 'PTPortalUser.PTCARDSECURITY'.DBCC results for 'PTPortalUser.LDAP_ATTRIBUTE_MAP'.There are 45 rows in 1 pages for object 'PTPortalUser.LDAP_ATTRIBUTE_MAP'.DBCC results for 'PTPortalUser.PTCARDPROPERTIES'.There are 18840 rows in 3920 pages for object 'PTPortalUser.PTCARDPROPERTIES'.DBCC results for 'PTPortalUser.LDAP_ENTRY_OBJECTCLASSES'.There are 5 rows in 2 pages for object 'PTPortalUser.LDAP_ENTRY_OBJECTCLASSES'.DBCC results for 'PTPortalUser.PTCARDSTATUS'.There are 14028 rows in 64 pages for object 'PTPortalUser.PTCARDSTATUS'.DBCC results for 'PTPortalUser.LDAP_ENTRIES'.There are 81498 rows in 2326 pages for object 'PTPortalUser.LDAP_ENTRIES'.DBCC results for 'PTPortalUser.PTCARDSTATISTICS'.There are 14026 rows in 72 pages for object 'PTPortalUser.PTCARDSTATISTICS'.DBCC results for 'PTPortalUser.PTFOLDERS'.There are 7471 rows in 119 pages for object 'PTPortalUser.PTFOLDERS'.DBCC results for 'PTPortalUser.PTAUDITMSGS_PRE65'.There are 59351 rows in 2206 pages for object 'PTPortalUser.PTAUDITMSGS_PRE65'.DBCC results for 'PTPortalUser.PTFOLDERCARDS'.There are 14698 rows in 67 pages for object 'PTPortalUser.PTFOLDERCARDS'.DBCC results for 'PTPortalUser.PTACCESSORREG'.There are 6 rows in 1 pages for object 'PTPortalUser.PTACCESSORREG'.DBCC results for 'PTPortalUser.PTFOLDERPATHS'.There are 7471 rows in 332 pages for object 'PTPortalUser.PTFOLDERPATHS'.DBCC results for 'PTPortalUser.PTDATASRCPROVREG'.There are 3 rows in 1 pages for object 'PTPortalUser.PTDATASRCPROVREG'.DBCC results for 'PTPortalUser.PTDBQUERIES'.There are 2 rows in 1 pages for object 'PTPortalUser.PTDBQUERIES'.DBCC results for 'PTPortalUser.PTFOLDERIDPATHS'.There are 7472 rows in 141 pages for object 'PTPortalUser.PTFOLDERIDPATHS'.DBCC results for 'PTPortalUser.PTGADGETPROVREG'.There are 2 rows in 1 pages for object 'PTPortalUser.PTGADGETPROVREG'.DBCC results for 'PTPortalUser.PTEXTDBQUERIES'.There are 0 rows in 0 pages for object 'PTPortalUser.PTEXTDBQUERIES'.DBCC results for 'PTPortalUser.PTFOLDERFILTERS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTFOLDERFILTERS'.DBCC results for 'PTPortalUser.PTAUTHPROVREG'.There are 3 rows in 1 pages for object 'PTPortalUser.PTAUTHPROVREG'.DBCC results for 'PTPortalUser.SAMPLEPICKTREE'.There are 9 rows in 1 pages for object 'PTPortalUser.SAMPLEPICKTREE'.DBCC results for 'PTPortalUser.PTFOLDERSECURITY'.There are 25947 rows in 105 pages for object 'PTPortalUser.PTFOLDERSECURITY'.DBCC results for 'PTPortalUser.PTCOMMONFIELDS'.There are 85 rows in 3 pages for object 'PTPortalUser.PTCOMMONFIELDS'.DBCC results for 'PTPortalUser.PTCOMMFOLDERS'.There are 0 rows in 0 pages for object 'PTPortalUser.PTCOMMFOLDERS'.CHECKDB found 0 allocation errors and 6 consistency errors in database 'PTPortal'.CHECKDB fixed 0 allocation errors and 3 consistency errors in database 'PTPortal'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (PTPortal repair_allow_data_loss).DBCC execution completed. If DBCC printed error messages, contact your system administrator.The statement has been terminated.===================================================================Tue, 15 Jan 2013 02:21:40 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote]jitendra.padhiyar (1/14/2013)[quote][/quote]Can torn page issue occurs due to lack of disk space ? I know torn page is the page that is not correctly written to disk. But can lack of free disk space can cuase torn page ?[/quote]No.[/quote]I agree with Gail. Low disk space would not result in a torn page. Pages are allocated when the DB engine allocates the space, and that is done by extents, not pages. You would get entirely different errors in the log if space were an issue.What do you get back from running the following command:dbcc checkdb (corruptDbName) with no_infomsgs, all_errormsgsMon, 14 Jan 2013 05:15:31 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote][b]Bhuvnesh (1/14/2013)[/b][hr]see the link [url]http://jeffprom.wordpress.com/2008/08/22/fixing-torn-page-headers/[/url][/quote]The solution he gave there is the absolute last resort for when there's no backup and checkDB can't repair the error. Furthermore, you should never detach a corrupt or suspect database (as he recommends) as there's a chance that the DB won't attach again.Mon, 14 Jan 2013 03:11:15 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote][b]jitendra.padhiyar (1/14/2013)[/b][hr]Moreover, its sql server 2000, what may be the solution ? Checkdb ?[/quote]Ideally, restore from a clean backup, but only once you know the severity of the problem.Take a look at this article. [url]http://www.sqlservercentral.com/articles/65804/[/url]Mon, 14 Jan 2013 03:09:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspx[quote][b]jitendra.padhiyar (1/14/2013)[/b][hr]Can torn page issue occurs due to lack of disk space ? I know torn page is the page that is not correctly written to disk. But can lack of free disk space can cuase torn page ?[/quote]No.Mon, 14 Jan 2013 03:08:13 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxyes, you can try Checkdb and at a side , i will suggest again go through the link which i posted aboveMon, 14 Jan 2013 02:54:32 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxHi Bhuvnesh,I am not sure about it...! I m just guessing and asking if disk shortage can cause torn page. Moreover, its sql server 2000, what may be the solution ? Checkdb ?Mon, 14 Jan 2013 02:46:37 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxI dont think disk shortage could lead to torn page, it generally happens because of system/disk outage.see the link [url]http://jeffprom.wordpress.com/2008/08/22/fixing-torn-page-headers/[/url]Mon, 14 Jan 2013 02:39:15 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1406601-1292-1.aspxHello Masters,Can torn page issue occurs due to lack of disk space ? I know torn page is the page that is not correctly written to disk. But can lack of free disk space can cuase torn page ?I am facing such an issue, I got one ticket where client was performing one DML operation and got torn page error "Msg 823, Level 24, State 2, Line 1I / O error (torn page) detected during read at offset 0x0000016fd34000 in file 'E: \ SQL Data \ Databaename.mdf'."On first investigation I found there was only 90KB free space available out of 199GB !!!! I than created about 60GB space by cleaning old backup files but can this disk issue lead to torn page error ?Just one to add one more point, this is SQL Server 2000 !Mon, 14 Jan 2013 02:11:23 GMTjitendra.padhiyar