January 14, 2013 at 2:11 am
Hello 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 1
I / 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 !
January 14, 2013 at 2:39 am
I dont think disk shortage could lead to torn page, it generally happens because of system/disk outage.
see the link http://jeffprom.wordpress.com/2008/08/22/fixing-torn-page-headers/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 2:46 am
Hi 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 ?
January 14, 2013 at 2:54 am
yes, you can try Checkdb and at a side , i will suggest again go through the link which i posted above
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 14, 2013 at 3:08 am
jitendra.padhiyar (1/14/2013)
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 ?
No.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2013 at 3:09 am
jitendra.padhiyar (1/14/2013)
Moreover, its sql server 2000, what may be the solution ? Checkdb ?
Ideally, restore from a clean backup, but only once you know the severity of the problem.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2013 at 3:11 am
Bhuvnesh (1/14/2013)
see the link http://jeffprom.wordpress.com/2008/08/22/fixing-torn-page-headers/
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2013 at 5:15 am
jitendra.padhiyar (1/14/2013)
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 ?
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_errormsgs
Joie Andrew
"Since 1982"
January 15, 2013 at 2:21 am
DBCC 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 1
The 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 1
The 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 1
Object 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 1
Table 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 1
Object 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 1
Table 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 1
Table 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 1
Table 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.
===================================================================
January 15, 2013 at 2:28 am
Err... 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
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2013 at 2:35 am
Ohh.. Is there any way to know how much data lost? Or how to find what table affected by that ?
January 15, 2013 at 2:49 am
jitendra.padhiyar (1/15/2013)
Ohh.. Is there any way to know how much data lost? Or how to find what table affected by that ?
How much, no, not after the fact. Which table, yes. The tables PTJOBOPHISTORY and PTJOBLOGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2013 at 3:05 am
Before 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...
Joie Andrew
"Since 1982"
January 15, 2013 at 4:11 am
Thanks 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 < 614469
and got error message:
Msg 8908, Level 22, State 6, Line 1
Table 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..
January 15, 2013 at 4:23 am
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!!
Is it advisable ?? Please help me masters...!
Viewing 15 posts - 1 through 15 (of 27 total)
You must be logged in to reply to this topic. Login to reply