Thread: consistency checks

consistency checks

From
Laurette Cisneros
Date:
We had an out of space problem that affected the 7.3.1 server we are running.
Some tables in various databases were being restored and there are
continuously running processes that insert data into several tables fairly
often.  We have 30+ databases on this server.

My question is this: how do I find if there was any corruption in the data
for those tables?  Will vacuum find this out?  Is there some other tool
that can be used to "hunt down" corruption?  This is to double check if any
harm was done by the out of space event.

Thanks,

--
Laurette Cisneros, L.D.
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
"No man is wise enough by himself"
-- Titus Maccius Plautus
   (254 Bc - 184 BC), Miles Gloriosus