Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Torn Page in table with unloved content


Torn Page in table with unloved content

Author
Message
kirkysql
kirkysql
Valued Member
Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)

Group: General Forum Members
Points: 64 Visits: 362
Hi
We 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?



John Mitchell-245523
John Mitchell-245523
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7474 Visits: 15142
I don't know the answer to your question, but I can tell you what I'd do. I'd restore a copy of the corrupted database on to a test server, and truncate the table there. You'll soon see whether the errors keep occurring. My guess is that dropping and recreating the table is more likely to work than just truncating it.

John
David Webb-CDS
David Webb-CDS
SSC Eights!
SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)

Group: General Forum Members
Points: 922 Visits: 8584
Truncate will probably work, but if you have a torn page you need to do a thorough check on your I/O system to see what might have caused it. If the base problem isn't remedied, you could get hit with this again on a table with data you need.



And then again, I might be wrong ...
David Webb
kirkysql
kirkysql
Valued Member
Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)

Group: General Forum Members
Points: 64 Visits: 362
Thanks.
I have requested a restore of the db to another server. We have known issues with our storage subsystem which are making life "interesting" and have been restoring up to know.
The business situation with this particular database is a little more complicated though.



kirkysql
kirkysql
Valued Member
Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)

Group: General Forum Members
Points: 64 Visits: 362
Just to let you know that the truncation worked and subsequent checkdb came back clean:-).

However when I check the suspect_pages table in msdb, I still see the corrupt page with status 3 (torn), although the last_update_date is no longer changing.

I'll likely remove this record from suspect_pages in a couple of weeks.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search