May 1, 2013 at 8:37 am
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?
May 1, 2013 at 8:52 am
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
May 1, 2013 at 9:05 am
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.
May 1, 2013 at 9:08 am
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.
May 1, 2013 at 2:09 pm
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply