July 10, 2002 at 9:32 am
Is there any code, sp, application out there that I can run to check a database/tables for corruption.
My problem is this: I run an application of of a palm. The application has been running problem free for over a year. No changes have been made to the code of the application or the database that stores the data. Suddenly the application is reporting only pieces of accurate data, and pieces of erroneous data. I have exhausted all my means of test the views, sp's, etc. that go along with the application. What else can I do? I have also done a DBCC, which didn't report any problems.
HELP!
Any assistance would be GREATLY appreciated.
July 10, 2002 at 9:59 am
DBCC is your only real check. It sounds like you have data integrity issues, which are different than corruption. Can you search all the tables affected to be sure there is not any erroneous data?
I'd also double check that no changes were made.
Steve Jones
July 10, 2002 at 12:22 pm
I am 100 percent positive that no data has been changed. Any ideas on how I can check each table for erroneous data. I can't really eye ball it and i'm not sure what script I would develop to handle the search.
Ideas?
quote:
DBCC is your only real check. It sounds like you have data integrity issues, which are different than corruption. Can you search all the tables affected to be sure there is not any erroneous data?I'd also double check that no changes were made.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
July 10, 2002 at 1:03 pm
If you know the data is erroneous, you have a place to start. The data you know is bad, figure out the source tables. Then you should be able to sufficiently narrow rows until you can analyze the exact rows returned. That should give you an indication if the data is different at the database level.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply