Database consistency check

[#1]

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]

Thanks a  lot @sriram..
i would really appricate if i could get any way ...how to ensure DB consistency in Sybase..as the core issue ..i raised...Plz help[

[S_Sriram]

Hi Sharad.

First do the DB check as mention the SAP Note by Prithviraj. check the any error in the DB?

BR

SS