Checking Sybase database for consistency(dbcc commands)

[#1]

Good afternoon, colleagues.

Tell me what there is common measures to check the Sybase database for consistency? I of course mean dbcc commands. I would be happy with any links and if you share your personal experience in this matter.

[Former Member · Accepted solution]

Based on my long Sybase experience I think the best way is to use 'dbcc checkstorage':

1. configure database dbcc

2. run from crontab checkstorage each day/week  (before full backup) on each important system/user database

3. check from crontab/Bradmark/"any other" tool:

  a) dbccdb..dbcc_operation_log if in last 24 h there was a dbcc checkstorage

  b) link tables dbccdb..dbcc_operation_results, dbccdb..dbcc_operation_log, dbccdb..dbcc_types, dbccdb..dbcc_faults and check if there are any soft or hard errors

4. if you will be given any alert about error then run (on your own)

  sp_dbcc_summaryreport @dbname = <datbase_name where was error>, @display_recommendations = 1

5. read output and there will be information which dbcc command you shoul run (in most cases it's work)

It is the most sufficient and optimal way of checking datbase consistency

[Former Member · Accepted solution]

Now that's similar to what I was saying. Just like training. I imagine something like this would be. Thank you for sharing experiences. That's what I intended to make the process of verifying the consistency of the database.