Database consistency check

[former_member262203]

Dear experts,

My Env is- Aix+Sybase. Backup device is tape. i need to take back-up daily so there is scheduler is set for the same.take backup of transactions hourly.

now issue is that  previously the size of my back-up .dmp(PRD sys) file was approx 55GB but all of sudden it reduced to 52 gb from last five days so i was scared if there would any data-loss..for that i just restored it on Test server and run dbcc checkdb.it took too much time i had to hault that after 6 hrs.
Both system is functioning properly no compalints from user and functional consultanats till date.

is there anyway to check DB intergrity..easily
Pl help

[former_member262203]

Former Member ..thanks for response
  i want to just confirm no data loss made...all of sudden 4 GB cant be reduced over a night...means it decreased by almost 7.8%...isnt it strange??
and i am unable to get output in DB12....
is there anyway to ensure its consistency and integrity.. at SAP Level??.

[Former Member]

Hi,

I still find it difficult to relate consistency check and backup image size relationship.

Anyway, go through below mentioned sap note

2226537 - SAP ASE DBCC checks

Regards,

Prithviraj.

[S_Sriram]

Hi Sharad.

On your production system have you carry out any database management (Any deletion)? or Everyday have you check the transaction log size? you can check over all the database size using the transaction DB02 space history.

Regards

SS