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?