Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Torn page issue Expand / Collapse
Author
Message
Posted Monday, January 14, 2013 2:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
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 !
Post #1406601
Posted Monday, January 14, 2013 2:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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
Post #1406610
Posted Monday, January 14, 2013 2:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
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 ?
Post #1406614
Posted Monday, January 14, 2013 2:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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
Post #1406620
Posted Monday, January 14, 2013 3:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 42,462, Visits: 35,525
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1406627
Posted Monday, January 14, 2013 3:09 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 42,462, Visits: 35,525
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1406628
Posted Monday, January 14, 2013 3:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 42,462, Visits: 35,525


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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1406630
Posted Monday, January 14, 2013 5:15 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:43 AM
Points: 709, Visits: 1,411
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"
Post #1406666
Posted Tuesday, January 15, 2013 2:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
DBCC Checkdb completed after long time of about 3 hours...!!! There are 0 allocation error but have seen some consistency errors.. 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.
===================================================================
Post #1407104
Posted Tuesday, January 15, 2013 2:28 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 42,462, Visits: 35,525
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1407107
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse